malloy logoMalloy Documentation

Name Game

You can find the complete source code for this model here.

The Data set consits of name, gender, state and year with the number of people that were born with that name in that gender, state and year.

query: table('bigquery-public-data.usa_names.usa_1910_2013')->{
  top: 10
  project: *
}
QUERY RESULTS
state gender year name number
AK F 1,910 Elsie 6
AL F 1,910 Annie 482
AL F 1,910 Katie 84
AL F 1,910 Alma 82
AL F 1,910 Thelma 65
AL F 1,910 Ellen 38
AL F 1,910 Rebecca 35
AL F 1,910 Estella 21
AL F 1,910 Corine 17
AL F 1,910 Margie 17
[
  {
    "state": "AK",
    "gender": "F",
    "year": 1910,
    "name": "Elsie",
    "number": 6
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Annie",
    "number": 482
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Katie",
    "number": 84
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Alma",
    "number": 82
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Thelma",
    "number": 65
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Ellen",
    "number": 38
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Rebecca",
    "number": 35
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Estella",
    "number": 21
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Corine",
    "number": 17
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Margie",
    "number": 17
  }
]
SELECT 
   base.state as state,
   base.gender as gender,
   base.year as year,
   base.name as name,
   base.number as number
FROM `bigquery-public-data.usa_names.usa_1910_2013` as base
LIMIT 10

The command above says query the table 'bigquery-public-data.usa_names.usa_1910_2013' and project (show) all the columns for the first 10 rows.

Grouping a query

In SQL there are basically two kinds of SELECT commands: SELECT ... GROUP BY and SELECT without a grouping. In malloy, these are two different commands. The command in malloy for SELECT ... GROUP BY is group_by. Since number and year are reserved words, we have to quote the names with back-tics.

query: table('bigquery-public-data.usa_names.usa_1910_2013')->{
  group_by: name
  aggregate: population is `number`.sum()
}
QUERY RESULTS
name population
James 4,942,431
John 4,834,422
Robert 4,718,787
Michael 4,297,230
William 3,822,209
Mary 3,737,679
David 3,549,801
Richard 2,531,924
Joseph 2,472,917
Charles 2,244,693
Thomas 2,212,781
Christopher 1,987,490
Daniel 1,842,964
Patricia 1,569,570
Matthew 1,538,689
Elizabeth 1,492,404
Jennifer 1,463,145
Linda 1,447,601
Barbara 1,424,203
Donald 1,402,666
Anthony 1,385,453
Paul 1,355,711
Mark 1,339,371
George 1,321,652
Steven 1,269,627
Kenneth 1,259,720
Andrew 1,228,080
Edward 1,210,315
Joshua 1,163,481
Brian 1,156,495
Kevin 1,148,680
Margaret 1,120,766
Susan 1,108,712
Ronald 1,074,141
Timothy 1,055,792
Dorothy 1,052,570
Jessica 1,038,359
Jason 1,009,416
Sarah 1,006,934
Betty 985,364
Nancy 984,185
Karen 982,192
Jeffrey 969,093
Lisa 962,981
Ryan 907,969
Gary 896,637
Helen 895,428
Sandra 870,958
Nicholas 867,231
Eric 862,204
Jacob 848,518
Stephen 844,930
Ashley 841,427
Donna 826,714
Kimberly 826,275
Frank 818,197
Carol 817,290
Jonathan 803,723
Michelle 803,162
Larry 801,398
Emily 779,755
Amanda 769,292
Scott 765,844
Justin 757,273
Laura 745,892
Melissa 745,498
Raymond 744,284
Deborah 735,869
Brandon 735,849
Stephanie 732,651
Rebecca 728,799
Ruth 728,678
Anna 719,803
Sharon 718,701
Kathleen 703,265
Cynthia 703,175
Gregory 701,504
Shirley 686,079
Samuel 681,358
Amy 673,234
Benjamin 664,328
Patrick 655,434
Angela 653,663
Jack 634,113
Virginia 621,448
Jerry 618,105
Dennis 610,894
Catherine 606,029
Brenda 604,067
Alexander 598,944
Katherine 593,220
Pamela 591,307
Nicole 576,870
Tyler 576,031
Christine 574,120
Henry 571,539
Walter 558,026
Peter 553,789
Douglas 552,666
Janet 550,557
[
  {
    "name": "James",
    "population": 4942431
  },
  {
    "name": "John",
    "population": 4834422
  },
  {
    "name": "Robert",
    "population": 4718787
  },
  {
    "name": "Michael",
    "population": 4297230
  },
  {
    "name": "William",
    "population": 3822209
  },
  {
    "name": "Mary",
    "population": 3737679
  },
  {
    "name": "David",
    "population": 3549801
  },
  {
    "name": "Richard",
    "population": 2531924
  },
  {
    "name": "Joseph",
    "population": 2472917
  },
  {
    "name": "Charles",
    "population": 2244693
  },
  {
    "name": "Thomas",
    "population": 2212781
  },
  {
    "name": "Christopher",
    "population": 1987490
  },
  {
    "name": "Daniel",
    "population": 1842964
  },
  {
    "name": "Patricia",
    "population": 1569570
  },
  {
    "name": "Matthew",
    "population": 1538689
  },
  {
    "name": "Elizabeth",
    "population": 1492404
  },
  {
    "name": "Jennifer",
    "population": 1463145
  },
  {
    "name": "Linda",
    "population": 1447601
  },
  {
    "name": "Barbara",
    "population": 1424203
  },
  {
    "name": "Donald",
    "population": 1402666
  },
  {
    "name": "Anthony",
    "population": 1385453
  },
  {
    "name": "Paul",
    "population": 1355711
  },
  {
    "name": "Mark",
    "population": 1339371
  },
  {
    "name": "George",
    "population": 1321652
  },
  {
    "name": "Steven",
    "population": 1269627
  },
  {
    "name": "Kenneth",
    "population": 1259720
  },
  {
    "name": "Andrew",
    "population": 1228080
  },
  {
    "name": "Edward",
    "population": 1210315
  },
  {
    "name": "Joshua",
    "population": 1163481
  },
  {
    "name": "Brian",
    "population": 1156495
  },
  {
    "name": "Kevin",
    "population": 1148680
  },
  {
    "name": "Margaret",
    "population": 1120766
  },
  {
    "name": "Susan",
    "population": 1108712
  },
  {
    "name": "Ronald",
    "population": 1074141
  },
  {
    "name": "Timothy",
    "population": 1055792
  },
  {
    "name": "Dorothy",
    "population": 1052570
  },
  {
    "name": "Jessica",
    "population": 1038359
  },
  {
    "name": "Jason",
    "population": 1009416
  },
  {
    "name": "Sarah",
    "population": 1006934
  },
  {
    "name": "Betty",
    "population": 985364
  },
  {
    "name": "Nancy",
    "population": 984185
  },
  {
    "name": "Karen",
    "population": 982192
  },
  {
    "name": "Jeffrey",
    "population": 969093
  },
  {
    "name": "Lisa",
    "population": 962981
  },
  {
    "name": "Ryan",
    "population": 907969
  },
  {
    "name": "Gary",
    "population": 896637
  },
  {
    "name": "Helen",
    "population": 895428
  },
  {
    "name": "Sandra",
    "population": 870958
  },
  {
    "name": "Nicholas",
    "population": 867231
  },
  {
    "name": "Eric",
    "population": 862204
  },
  {
    "name": "Jacob",
    "population": 848518
  },
  {
    "name": "Stephen",
    "population": 844930
  },
  {
    "name": "Ashley",
    "population": 841427
  },
  {
    "name": "Donna",
    "population": 826714
  },
  {
    "name": "Kimberly",
    "population": 826275
  },
  {
    "name": "Frank",
    "population": 818197
  },
  {
    "name": "Carol",
    "population": 817290
  },
  {
    "name": "Jonathan",
    "population": 803723
  },
  {
    "name": "Michelle",
    "population": 803162
  },
  {
    "name": "Larry",
    "population": 801398
  },
  {
    "name": "Emily",
    "population": 779755
  },
  {
    "name": "Amanda",
    "population": 769292
  },
  {
    "name": "Scott",
    "population": 765844
  },
  {
    "name": "Justin",
    "population": 757273
  },
  {
    "name": "Laura",
    "population": 745892
  },
  {
    "name": "Melissa",
    "population": 745498
  },
  {
    "name": "Raymond",
    "population": 744284
  },
  {
    "name": "Deborah",
    "population": 735869
  },
  {
    "name": "Brandon",
    "population": 735849
  },
  {
    "name": "Stephanie",
    "population": 732651
  },
  {
    "name": "Rebecca",
    "population": 728799
  },
  {
    "name": "Ruth",
    "population": 728678
  },
  {
    "name": "Anna",
    "population": 719803
  },
  {
    "name": "Sharon",
    "population": 718701
  },
  {
    "name": "Kathleen",
    "population": 703265
  },
  {
    "name": "Cynthia",
    "population": 703175
  },
  {
    "name": "Gregory",
    "population": 701504
  },
  {
    "name": "Shirley",
    "population": 686079
  },
  {
    "name": "Samuel",
    "population": 681358
  },
  {
    "name": "Amy",
    "population": 673234
  },
  {
    "name": "Benjamin",
    "population": 664328
  },
  {
    "name": "Patrick",
    "population": 655434
  },
  {
    "name": "Angela",
    "population": 653663
  },
  {
    "name": "Jack",
    "population": 634113
  },
  {
    "name": "Virginia",
    "population": 621448
  },
  {
    "name": "Jerry",
    "population": 618105
  },
  {
    "name": "Dennis",
    "population": 610894
  },
  {
    "name": "Catherine",
    "population": 606029
  },
  {
    "name": "Brenda",
    "population": 604067
  },
  {
    "name": "Alexander",
    "population": 598944
  },
  {
    "name": "Katherine",
    "population": 593220
  },
  {
    "name": "Pamela",
    "population": 591307
  },
  {
    "name": "Nicole",
    "population": 576870
  },
  {
    "name": "Tyler",
    "population": 576031
  },
  {
    "name": "Christine",
    "population": 574120
  },
  {
    "name": "Henry",
    "population": 571539
  },
  {
    "name": "Walter",
    "population": 558026
  },
  {
    "name": "Peter",
    "population": 553789
  },
  {
    "name": "Douglas",
    "population": 552666
  },
  {
    "name": "Janet",
    "population": 550557
  }
]
SELECT 
   base.name as name,
   SUM(base.number) as population
FROM `bigquery-public-data.usa_names.usa_1910_2013` as base
GROUP BY 1
ORDER BY 2 desc

malloy compiles to SQL. The SQL query for the above command is.

SELECT
   base.name as name,
   SUM(base.number) as population
FROM `bigquery-public-data.usa_names.usa_1910_2013` as base
GROUP BY 1
ORDER BY 2 desc

Expressions

Expressions work much the same as they do in SQL. We can look at population over decade by using a calculation against the year.

query: table('bigquery-public-data.usa_names.usa_1910_2013')->{
  top: 10
  group_by: decade is FLOOR(`year`/10)*10
  aggregate: population is sum(`number`)
}
QUERY RESULTS
decade population
1,950 37,545,138
1,960 35,405,002
1,990 33,309,594
2,000 33,041,629
1,980 32,349,146
1,970 29,238,092
1,940 27,776,913
1,920 21,375,400
1,930 19,782,373
1,910 13,592,350
[
  {
    "decade": 1950,
    "population": 37545138
  },
  {
    "decade": 1960,
    "population": 35405002
  },
  {
    "decade": 1990,
    "population": 33309594
  },
  {
    "decade": 2000,
    "population": 33041629
  },
  {
    "decade": 1980,
    "population": 32349146
  },
  {
    "decade": 1970,
    "population": 29238092
  },
  {
    "decade": 1940,
    "population": 27776913
  },
  {
    "decade": 1920,
    "population": 21375400
  },
  {
    "decade": 1930,
    "population": 19782373
  },
  {
    "decade": 1910,
    "population": 13592350
  }
]
SELECT 
   (FLOOR(base.year/10))*10 as decade,
   SUM(base.number) as population
FROM `bigquery-public-data.usa_names.usa_1910_2013` as base
GROUP BY 1
ORDER BY 2 desc
LIMIT 10

Cohorts

explore: names is from(
  table('bigquery-public-data.usa_names.usa_1910_2013')->
  {
    group_by: [
      decade is floor(`year`/10)*10
      state
      gender
    ]
    aggregate: cohort_population is `number`.sum()
    nest: by_name is {
      group_by: name
      aggregate: population is `number`.sum()
    }
  }
){
  measure: births_per_100k is FLOOR(by_name.population.sum()/cohort_population.sum() *100000)
  measure: total_cohort_population is cohort_population.sum()
  dimension: name is concat(by_name.name,'')
}

query: names->{
  group_by: [
    state
    gender
  ]
  aggregate: total_cohort_population
  nest: names is {
    where: name : 'Michael'|'Lloyd'|'Olivia'
    group_by: name
    aggregate: population is by_name.population.sum()
    group_by: births_per_100k
  }
}
QUERY RESULTS
state gender total_​cohort_​population names
CA M 15,011,405
name population births_​per_​100k
Michael 420,127 2,798
Lloyd 8,380 55
CA F 13,799,158
name population births_​per_​100k
Olivia 33,794 244
Michael 2,428 19
NY M 12,203,961
name population births_​per_​100k
Michael 430,732 3,529
Lloyd 7,568 62
Olivia 5 0
NY F 11,490,175
name population births_​per_​100k
Olivia 23,219 202
Michael 1,761 16
TX M 11,126,246
name population births_​per_​100k
Michael 223,900 2,012
Lloyd 8,461 76
Olivia 6 1
TX F 10,341,113
name population births_​per_​100k
Olivia 25,746 248
Michael 1,420 16
Lloyd 15 1
PA M 8,497,961
name population births_​per_​100k
Michael 266,380 3,134
Lloyd 7,874 92
Olivia 22 2
PA F 8,163,949
name population births_​per_​100k
Olivia 16,292 199
Michael 910 11
IL M 7,845,252
name population births_​per_​100k
Michael 251,741 3,208
Lloyd 7,207 91
IL F 7,333,624
name population births_​per_​100k
Olivia 16,450 224
Michael 989 17
OH M 7,324,810
name population births_​per_​100k
Michael 225,302 3,075
Lloyd 6,755 92
OH F 6,876,716
name population births_​per_​100k
Olivia 16,787 244
Michael 969 18
MI M 6,036,661
name population births_​per_​100k
Michael 194,851 3,227
Lloyd 6,130 101
MI F 5,606,794
name population births_​per_​100k
Olivia 13,575 242
Michael 755 17
FL M 4,910,950
name population births_​per_​100k
Michael 138,882 2,828
Lloyd 2,876 58
FL F 4,366,273
name population births_​per_​100k
Olivia 15,208 348
Michael 691 18
NC M 4,326,810
name population births_​per_​100k
Michael 92,414 2,135
Lloyd 4,367 100
NJ M 4,315,822
name population births_​per_​100k
Michael 165,385 3,832
Lloyd 1,720 41
GA M 4,214,825
name population births_​per_​100k
Michael 87,684 2,080
Lloyd 2,508 59
NC F 4,113,425
name population births_​per_​100k
Olivia 10,671 259
Michael 416 19
[
  {
    "state": "CA",
    "gender": "M",
    "total_cohort_population": 15011405,
    "names": [
      {
        "name": "Michael",
        "population": 420127,
        "births_per_100k": 2798
      },
      {
        "name": "Lloyd",
        "population": 8380,
        "births_per_100k": 55
      }
    ]
  },
  {
    "state": "CA",
    "gender": "F",
    "total_cohort_population": 13799158,
    "names": [
      {
        "name": "Olivia",
        "population": 33794,
        "births_per_100k": 244
      },
      {
        "name": "Michael",
        "population": 2428,
        "births_per_100k": 19
      }
    ]
  },
  {
    "state": "NY",
    "gender": "M",
    "total_cohort_population": 12203961,
    "names": [
      {
        "name": "Michael",
        "population": 430732,
        "births_per_100k": 3529
      },
      {
        "name": "Lloyd",
        "population": 7568,
        "births_per_100k": 62
      },
      {
        "name": "Olivia",
        "population": 5,
        "births_per_100k": 0
      }
    ]
  },
  {
    "state": "NY",
    "gender": "F",
    "total_cohort_population": 11490175,
    "names": [
      {
        "name": "Olivia",
        "population": 23219,
        "births_per_100k": 202
      },
      {
        "name": "Michael",
        "population": 1761,
        "births_per_100k": 16
      }
    ]
  },
  {
    "state": "TX",
    "gender": "M",
    "total_cohort_population": 11126246,
    "names": [
      {
        "name": "Michael",
        "population": 223900,
        "births_per_100k": 2012
      },
      {
        "name": "Lloyd",
        "population": 8461,
        "births_per_100k": 76
      },
      {
        "name": "Olivia",
        "population": 6,
        "births_per_100k": 1
      }
    ]
  },
  {
    "state": "TX",
    "gender": "F",
    "total_cohort_population": 10341113,
    "names": [
      {
        "name": "Olivia",
        "population": 25746,
        "births_per_100k": 248
      },
      {
        "name": "Michael",
        "population": 1420,
        "births_per_100k": 16
      },
      {
        "name": "Lloyd",
        "population": 15,
        "births_per_100k": 1
      }
    ]
  },
  {
    "state": "PA",
    "gender": "M",
    "total_cohort_population": 8497961,
    "names": [
      {
        "name": "Michael",
        "population": 266380,
        "births_per_100k": 3134
      },
      {
        "name": "Lloyd",
        "population": 7874,
        "births_per_100k": 92
      },
      {
        "name": "Olivia",
        "population": 22,
        "births_per_100k": 2
      }
    ]
  },
  {
    "state": "PA",
    "gender": "F",
    "total_cohort_population": 8163949,
    "names": [
      {
        "name": "Olivia",
        "population": 16292,
        "births_per_100k": 199
      },
      {
        "name": "Michael",
        "population": 910,
        "births_per_100k": 11
      }
    ]
  },
  {
    "state": "IL",
    "gender": "M",
    "total_cohort_population": 7845252,
    "names": [
      {
        "name": "Michael",
        "population": 251741,
        "births_per_100k": 3208
      },
      {
        "name": "Lloyd",
        "population": 7207,
        "births_per_100k": 91
      }
    ]
  },
  {
    "state": "IL",
    "gender": "F",
    "total_cohort_population": 7333624,
    "names": [
      {
        "name": "Olivia",
        "population": 16450,
        "births_per_100k": 224
      },
      {
        "name": "Michael",
        "population": 989,
        "births_per_100k": 17
      }
    ]
  },
  {
    "state": "OH",
    "gender": "M",
    "total_cohort_population": 7324810,
    "names": [
      {
        "name": "Michael",
        "population": 225302,
        "births_per_100k": 3075
      },
      {
        "name": "Lloyd",
        "population": 6755,
        "births_per_100k": 92
      }
    ]
  },
  {
    "state": "OH",
    "gender": "F",
    "total_cohort_population": 6876716,
    "names": [
      {
        "name": "Olivia",
        "population": 16787,
        "births_per_100k": 244
      },
      {
        "name": "Michael",
        "population": 969,
        "births_per_100k": 18
      }
    ]
  },
  {
    "state": "MI",
    "gender": "M",
    "total_cohort_population": 6036661,
    "names": [
      {
        "name": "Michael",
        "population": 194851,
        "births_per_100k": 3227
      },
      {
        "name": "Lloyd",
        "population": 6130,
        "births_per_100k": 101
      }
    ]
  },
  {
    "state": "MI",
    "gender": "F",
    "total_cohort_population": 5606794,
    "names": [
      {
        "name": "Olivia",
        "population": 13575,
        "births_per_100k": 242
      },
      {
        "name": "Michael",
        "population": 755,
        "births_per_100k": 17
      }
    ]
  },
  {
    "state": "FL",
    "gender": "M",
    "total_cohort_population": 4910950,
    "names": [
      {
        "name": "Michael",
        "population": 138882,
        "births_per_100k": 2828
      },
      {
        "name": "Lloyd",
        "population": 2876,
        "births_per_100k": 58
      }
    ]
  },
  {
    "state": "FL",
    "gender": "F",
    "total_cohort_population": 4366273,
    "names": [
      {
        "name": "Olivia",
        "population": 15208,
        "births_per_100k": 348
      },
      {
        "name": "Michael",
        "population": 691,
        "births_per_100k": 18
      }
    ]
  },
  {
    "state": "NC",
    "gender": "M",
    "total_cohort_population": 4326810,
    "names": [
      {
        "name": "Michael",
        "population": 92414,
        "births_per_100k": 2135
      },
      {
        "name": "Lloyd",
        "population": 4367,
        "births_per_100k": 100
      }
    ]
  },
  {
    "state": "NJ",
    "gender": "M",
    "total_cohort_population": 4315822,
    "names": [
      {
        "name": "Michael",
        "population": 165385,
        "births_per_100k": 3832
      },
      {
        "name": "Lloyd",
        "population": 1720,
        "births_per_100k": 41
      }
    ]
  },
  {
    "state": "GA",
    "gender": "M",
    "total_cohort_population": 4214825,
    "names": [
      {
        "name": "Michael",
        "population": 87684,
        "births_per_100k": 2080
      },
      {
        "name": "Lloyd",
        "population": 2508,
        "births_per_100k": 59
      }
    ]
  },
  {
    "state": "NC",
    "gender": "F",
    "total_cohort_population": 4113425,
    "names": [
      {
        "name": "Olivia",
        "population": 10671,
        "births_per_100k": 259
      },
      {
        "name": "Michael",
        "population": 416,
        "births_per_100k": 19
      }
    ]
  }
]
WITH __stage0 AS (
  SELECT
    group_set,
    (floor(base.year/10))*10 as decade__0,
    base.state as state__0,
    base.gender as gender__0,
    CASE WHEN group_set=0 THEN SUM(base.number) END as cohort_population__0,
    CASE WHEN group_set=1 THEN base.name END as name__1,
    CASE WHEN group_set=1 THEN SUM(base.number) END as population__1
  FROM `bigquery-public-data.usa_names.usa_1910_2013` as base
  CROSS JOIN (SELECT row_number() OVER() -1  group_set FROM UNNEST(GENERATE_ARRAY(0,1,1)))
  GROUP BY 1,2,3,4,6
)
, __stage1 AS (
  SELECT
    decade__0 as decade,
    state__0 as state,
    gender__0 as gender,
    ANY_VALUE(CASE WHEN group_set=0 THEN cohort_population__0 END) as cohort_population,
    ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT(name__1 as name, population__1 as population) END IGNORE NULLS  ORDER BY  population__1 desc ) as by_name
  FROM __stage0
  GROUP BY 1,2,3
  ORDER BY 4 desc
)
, __stage2 AS (
  SELECT
    group_set,
    names.state as state__0,
    names.gender as gender__0,
    CASE WHEN group_set=0 THEN CAST((
      (
        SUM(DISTINCT
          (CAST(ROUND(COALESCE(names.cohort_population,0)*(1*1.0), 9) AS NUMERIC) +
          (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001
        ))
        -
         SUM(DISTINCT (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001)
      )/(1*1.0)) as FLOAT64) END as total_cohort_population__0,
    CASE WHEN group_set=1 THEN concat(by_name_0.name,'') END as name__1,
    CASE WHEN group_set=1 THEN SUM(by_name_0.population) END as population__1,
    CASE WHEN group_set=1 THEN FLOOR((SUM(by_name_0.population)/CAST((
      (
        SUM(DISTINCT
          (CAST(ROUND(COALESCE(names.cohort_population,0)*(1*1.0), 9) AS NUMERIC) +
          (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001
        ))
        -
         SUM(DISTINCT (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001)
      )/(1*1.0)) as FLOAT64))*100000) END as births_per_100k__1
  FROM (SELECT GENERATE_UUID() as __distinct_key, * FROM __stage1) as names
  , UNNEST(names.by_name) as by_name_0
  CROSS JOIN (SELECT row_number() OVER() -1  group_set FROM UNNEST(GENERATE_ARRAY(0,1,1)))
  WHERE (group_set NOT IN (1) OR (group_set IN (1) AND (concat(by_name_0.name,'')='Michael')or((concat(by_name_0.name,'')='Lloyd')or(concat(by_name_0.name,'')='Olivia'))))
  GROUP BY 1,2,3,5
)
SELECT
  state__0 as state,
  gender__0 as gender,
  ANY_VALUE(CASE WHEN group_set=0 THEN total_cohort_population__0 END) as total_cohort_population,
  ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT(name__1 as name, population__1 as population, births_per_100k__1 as births_per_100k) END IGNORE NULLS  ORDER BY  population__1 desc ) as names
FROM __stage2
GROUP BY 1,2
ORDER BY 3 desc

Dashboard

query: names-> name_dashboard {where: name ~ 'Mich%'}
QUERY RESULTS
name total_​population state_​map decade_​graph
Michael 4,297,230 1,5002,0002,5003,0003,500births_per_100k 1,9201,9401,9601,9802,000decade02,0004,000births_per_100kFemaleMalebaby_gender
Michelle 803,162 4006008001,000births_per_100k 1,9201,9401,9601,9802,000decade05001,0001,5002,000births_per_100kFemaleMalebaby_gender
Michele 221,675 100200300400births_per_100k 1,9201,9401,9601,9802,000decade0200400births_per_100kFemaleMalebaby_gender
Micheal 149,601 50100150200births_per_100k 1,9201,9401,9601,9802,000decade0100200births_per_100kFemaleMalebaby_gender
Michaela 44,588 50100150200births_per_100k 1,9401,9601,9802,000decade050100150births_per_100kFemaleMalebaby_gender
Michel 7,022 10203040births_per_100k 1,9201,9401,9601,9802,000decade02468births_per_100kFemaleMalebaby_gender
Michell 4,371 5101520births_per_100k 1,9601,9802,000decade0510births_per_100kFemaleMalebaby_gender
Michal 2,165 02468births_per_100k 1,9401,9601,9802,000decade0510births_per_100kFemaleMalebaby_gender
Michale 966 1234births_per_100k 1,9601,9802,000decade0123births_per_100kMalebaby_gender
Michelina 892 2468births_per_100k 1,9201,9401,9601,9802,000decade0510births_per_100kFemalebaby_gender
Michaella 659 123456births_per_100k 1,9601,9701,9801,9902,0002,010decade01234births_per_100kFemalebaby_gender
Michela 598 24681012births_per_100k 1,9401,9601,9802,000decade024births_per_100kFemalebaby_gender
Michaelene 477 01234births_per_100k 1,9301,9401,9501,9601,9701,980decade01234births_per_100kFemalebaby_gender
Michaelangelo 467 0123births_per_100k 1,9701,9801,9902,0002,010decade0123births_per_100kMalebaby_gender
Michala 465 02468births_per_100k 1,9701,9801,9902,000decade024births_per_100kFemalebaby_gender
[
  {
    "name": "Michael",
    "total_population": 4297230,
    "state_map": [
      {
        "state": "RI",
        "births_per_100k": 3791
      },
      {
        "state": "AK",
        "births_per_100k": 3549
      },
      {
        "state": "DE",
        "births_per_100k": 3461
      },
      {
        "state": "VT",
        "births_per_100k": 3121
      },
      {
        "state": "NH",
        "births_per_100k": 2920
      },
      {
        "state": "ME",
        "births_per_100k": 2888
      },
      {
        "state": "WY",
        "births_per_100k": 2736
      },
      {
        "state": "NV",
        "births_per_100k": 2720
      },
      {
        "state": "HI",
        "births_per_100k": 2629
      },
      {
        "state": "CT",
        "births_per_100k": 2535
      },
      {
        "state": "DC",
        "births_per_100k": 2376
      },
      {
        "state": "MT",
        "births_per_100k": 2358
      },
      {
        "state": "SD",
        "births_per_100k": 2304
      },
      {
        "state": "MA",
        "births_per_100k": 2278
      },
      {
        "state": "NJ",
        "births_per_100k": 2273
      },
      {
        "state": "ID",
        "births_per_100k": 2071
      },
      {
        "state": "ND",
        "births_per_100k": 2035
      },
      {
        "state": "MD",
        "births_per_100k": 2019
      },
      {
        "state": "NE",
        "births_per_100k": 1972
      },
      {
        "state": "WI",
        "births_per_100k": 1967
      },
      {
        "state": "OR",
        "births_per_100k": 1950
      },
      {
        "state": "NY",
        "births_per_100k": 1913
      },
      {
        "state": "IL",
        "births_per_100k": 1885
      },
      {
        "state": "MI",
        "births_per_100k": 1870
      },
      {
        "state": "WV",
        "births_per_100k": 1825
      },
      {
        "state": "CO",
        "births_per_100k": 1822
      },
      {
        "state": "IA",
        "births_per_100k": 1815
      },
      {
        "state": "OH",
        "births_per_100k": 1794
      },
      {
        "state": "NM",
        "births_per_100k": 1769
      },
      {
        "state": "MN",
        "births_per_100k": 1749
      },
      {
        "state": "WA",
        "births_per_100k": 1745
      },
      {
        "state": "IN",
        "births_per_100k": 1729
      },
      {
        "state": "VA",
        "births_per_100k": 1704
      },
      {
        "state": "UT",
        "births_per_100k": 1699
      },
      {
        "state": "MO",
        "births_per_100k": 1696
      },
      {
        "state": "AZ",
        "births_per_100k": 1685
      },
      {
        "state": "KS",
        "births_per_100k": 1645
      },
      {
        "state": "PA",
        "births_per_100k": 1624
      },
      {
        "state": "FL",
        "births_per_100k": 1617
      },
      {
        "state": "OK",
        "births_per_100k": 1585
      },
      {
        "state": "CA",
        "births_per_100k": 1537
      },
      {
        "state": "LA",
        "births_per_100k": 1460
      },
      {
        "state": "NC",
        "births_per_100k": 1443
      },
      {
        "state": "AR",
        "births_per_100k": 1414
      },
      {
        "state": "TN",
        "births_per_100k": 1403
      },
      {
        "state": "SC",
        "births_per_100k": 1392
      },
      {
        "state": "KY",
        "births_per_100k": 1370
      },
      {
        "state": "AL",
        "births_per_100k": 1260
      },
      {
        "state": "GA",
        "births_per_100k": 1242
      },
      {
        "state": "MS",
        "births_per_100k": 1229
      },
      {
        "state": "TX",
        "births_per_100k": 1133
      }
    ],
    "decade_graph": [
      {
        "decade": 1970,
        "births_per_100k": 4562,
        "baby_gender": "Male"
      },
      {
        "decade": 1960,
        "births_per_100k": 4510,
        "baby_gender": "Male"
      },
      {
        "decade": 1950,
        "births_per_100k": 4301,
        "baby_gender": "Male"
      },
      {
        "decade": 1980,
        "births_per_100k": 3848,
        "baby_gender": "Male"
      },
      {
        "decade": 1990,
        "births_per_100k": 2588,
        "baby_gender": "Male"
      },
      {
        "decade": 1940,
        "births_per_100k": 2367,
        "baby_gender": "Male"
      },
      {
        "decade": 2000,
        "births_per_100k": 1409,
        "baby_gender": "Male"
      },
      {
        "decade": 2010,
        "births_per_100k": 988,
        "baby_gender": "Male"
      },
      {
        "decade": 1930,
        "births_per_100k": 564,
        "baby_gender": "Male"
      },
      {
        "decade": 1910,
        "births_per_100k": 501,
        "baby_gender": "Male"
      },
      {
        "decade": 1920,
        "births_per_100k": 366,
        "baby_gender": "Male"
      },
      {
        "decade": 1970,
        "births_per_100k": 35,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 32,
        "baby_gender": "Female"
      },
      {
        "decade": 1960,
        "births_per_100k": 19,
        "baby_gender": "Female"
      },
      {
        "decade": 1950,
        "births_per_100k": 10,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 10,
        "baby_gender": "Female"
      },
      {
        "decade": 1940,
        "births_per_100k": 8,
        "baby_gender": "Female"
      },
      {
        "decade": 1930,
        "births_per_100k": 4,
        "baby_gender": "Female"
      },
      {
        "decade": 1920,
        "births_per_100k": 4,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 1910,
        "births_per_100k": 0,
        "baby_gender": "Female"
      }
    ]
  },
  {
    "name": "Michelle",
    "total_population": 803162,
    "state_map": [
      {
        "state": "VT",
        "births_per_100k": 1136
      },
      {
        "state": "AK",
        "births_per_100k": 1099
      },
      {
        "state": "HI",
        "births_per_100k": 1042
      },
      {
        "state": "WY",
        "births_per_100k": 993
      },
      {
        "state": "DE",
        "births_per_100k": 984
      },
      {
        "state": "NH",
        "births_per_100k": 982
      },
      {
        "state": "RI",
        "births_per_100k": 950
      },
      {
        "state": "NV",
        "births_per_100k": 904
      },
      {
        "state": "NE",
        "births_per_100k": 899
      },
      {
        "state": "ND",
        "births_per_100k": 899
      },
      {
        "state": "ME",
        "births_per_100k": 889
      },
      {
        "state": "CO",
        "births_per_100k": 851
      },
      {
        "state": "SD",
        "births_per_100k": 834
      },
      {
        "state": "NM",
        "births_per_100k": 824
      },
      {
        "state": "UT",
        "births_per_100k": 818
      },
      {
        "state": "MT",
        "births_per_100k": 808
      },
      {
        "state": "OR",
        "births_per_100k": 806
      },
      {
        "state": "KS",
        "births_per_100k": 799
      },
      {
        "state": "IA",
        "births_per_100k": 799
      },
      {
        "state": "CT",
        "births_per_100k": 795
      },
      {
        "state": "WA",
        "births_per_100k": 783
      },
      {
        "state": "AZ",
        "births_per_100k": 779
      },
      {
        "state": "ID",
        "births_per_100k": 752
      },
      {
        "state": "DC",
        "births_per_100k": 742
      },
      {
        "state": "MO",
        "births_per_100k": 711
      },
      {
        "state": "MA",
        "births_per_100k": 678
      },
      {
        "state": "IN",
        "births_per_100k": 646
      },
      {
        "state": "MN",
        "births_per_100k": 625
      },
      {
        "state": "MD",
        "births_per_100k": 615
      },
      {
        "state": "MI",
        "births_per_100k": 585
      },
      {
        "state": "WI",
        "births_per_100k": 553
      },
      {
        "state": "OH",
        "births_per_100k": 545
      },
      {
        "state": "OK",
        "births_per_100k": 542
      },
      {
        "state": "LA",
        "births_per_100k": 525
      },
      {
        "state": "VA",
        "births_per_100k": 524
      },
      {
        "state": "NJ",
        "births_per_100k": 523
      },
      {
        "state": "FL",
        "births_per_100k": 500
      },
      {
        "state": "IL",
        "births_per_100k": 482
      },
      {
        "state": "PA",
        "births_per_100k": 475
      },
      {
        "state": "CA",
        "births_per_100k": 465
      },
      {
        "state": "WV",
        "births_per_100k": 462
      },
      {
        "state": "AR",
        "births_per_100k": 453
      },
      {
        "state": "SC",
        "births_per_100k": 440
      },
      {
        "state": "NY",
        "births_per_100k": 426
      },
      {
        "state": "KY",
        "births_per_100k": 384
      },
      {
        "state": "TN",
        "births_per_100k": 353
      },
      {
        "state": "GA",
        "births_per_100k": 339
      },
      {
        "state": "TX",
        "births_per_100k": 324
      },
      {
        "state": "MS",
        "births_per_100k": 317
      },
      {
        "state": "NC",
        "births_per_100k": 302
      },
      {
        "state": "AL",
        "births_per_100k": 295
      }
    ],
    "decade_graph": [
      {
        "decade": 1970,
        "births_per_100k": 1814,
        "baby_gender": "Female"
      },
      {
        "decade": 1960,
        "births_per_100k": 1230,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 1018,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 559,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 283,
        "baby_gender": "Female"
      },
      {
        "decade": 1950,
        "births_per_100k": 258,
        "baby_gender": "Female"
      },
      {
        "decade": 2010,
        "births_per_100k": 149,
        "baby_gender": "Female"
      },
      {
        "decade": 1940,
        "births_per_100k": 40,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 5,
        "baby_gender": "Male"
      },
      {
        "decade": 1980,
        "births_per_100k": 4,
        "baby_gender": "Male"
      },
      {
        "decade": 1930,
        "births_per_100k": 4,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 3,
        "baby_gender": "Male"
      },
      {
        "decade": 1960,
        "births_per_100k": 2,
        "baby_gender": "Male"
      },
      {
        "decade": 1920,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 0,
        "baby_gender": "Male"
      }
    ]
  },
  {
    "name": "Michele",
    "total_population": 221675,
    "state_map": [
      {
        "state": "DE",
        "births_per_100k": 472
      },
      {
        "state": "CT",
        "births_per_100k": 448
      },
      {
        "state": "HI",
        "births_per_100k": 368
      },
      {
        "state": "VT",
        "births_per_100k": 351
      },
      {
        "state": "MD",
        "births_per_100k": 325
      },
      {
        "state": "RI",
        "births_per_100k": 313
      },
      {
        "state": "DC",
        "births_per_100k": 294
      },
      {
        "state": "AK",
        "births_per_100k": 287
      },
      {
        "state": "NJ",
        "births_per_100k": 284
      },
      {
        "state": "NH",
        "births_per_100k": 276
      },
      {
        "state": "SD",
        "births_per_100k": 265
      },
      {
        "state": "NV",
        "births_per_100k": 256
      },
      {
        "state": "MT",
        "births_per_100k": 245
      },
      {
        "state": "WI",
        "births_per_100k": 234
      },
      {
        "state": "ME",
        "births_per_100k": 232
      },
      {
        "state": "NE",
        "births_per_100k": 224
      },
      {
        "state": "IA",
        "births_per_100k": 224
      },
      {
        "state": "WY",
        "births_per_100k": 217
      },
      {
        "state": "ND",
        "births_per_100k": 216
      },
      {
        "state": "PA",
        "births_per_100k": 215
      },
      {
        "state": "MN",
        "births_per_100k": 208
      },
      {
        "state": "UT",
        "births_per_100k": 200
      },
      {
        "state": "MI",
        "births_per_100k": 199
      },
      {
        "state": "IN",
        "births_per_100k": 195
      },
      {
        "state": "OR",
        "births_per_100k": 187
      },
      {
        "state": "MO",
        "births_per_100k": 186
      },
      {
        "state": "MA",
        "births_per_100k": 184
      },
      {
        "state": "WA",
        "births_per_100k": 176
      },
      {
        "state": "ID",
        "births_per_100k": 175
      },
      {
        "state": "OH",
        "births_per_100k": 171
      },
      {
        "state": "KS",
        "births_per_100k": 170
      },
      {
        "state": "CO",
        "births_per_100k": 163
      },
      {
        "state": "NY",
        "births_per_100k": 158
      },
      {
        "state": "WV",
        "births_per_100k": 147
      },
      {
        "state": "IL",
        "births_per_100k": 139
      },
      {
        "state": "NM",
        "births_per_100k": 136
      },
      {
        "state": "VA",
        "births_per_100k": 132
      },
      {
        "state": "AZ",
        "births_per_100k": 116
      },
      {
        "state": "KY",
        "births_per_100k": 112
      },
      {
        "state": "LA",
        "births_per_100k": 112
      },
      {
        "state": "FL",
        "births_per_100k": 109
      },
      {
        "state": "OK",
        "births_per_100k": 106
      },
      {
        "state": "CA",
        "births_per_100k": 100
      },
      {
        "state": "AR",
        "births_per_100k": 87
      },
      {
        "state": "SC",
        "births_per_100k": 73
      },
      {
        "state": "AL",
        "births_per_100k": 68
      },
      {
        "state": "GA",
        "births_per_100k": 64
      },
      {
        "state": "TX",
        "births_per_100k": 63
      },
      {
        "state": "NC",
        "births_per_100k": 60
      },
      {
        "state": "MS",
        "births_per_100k": 51
      },
      {
        "state": "TN",
        "births_per_100k": 47
      }
    ],
    "decade_graph": [
      {
        "decade": 1960,
        "births_per_100k": 513,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 411,
        "baby_gender": "Female"
      },
      {
        "decade": 1950,
        "births_per_100k": 231,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 113,
        "baby_gender": "Female"
      },
      {
        "decade": 1940,
        "births_per_100k": 84,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 36,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 10,
        "baby_gender": "Female"
      },
      {
        "decade": 1910,
        "births_per_100k": 7,
        "baby_gender": "Male"
      },
      {
        "decade": 1920,
        "births_per_100k": 5,
        "baby_gender": "Male"
      },
      {
        "decade": 1930,
        "births_per_100k": 5,
        "baby_gender": "Female"
      },
      {
        "decade": 2010,
        "births_per_100k": 4,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 4,
        "baby_gender": "Male"
      },
      {
        "decade": 1980,
        "births_per_100k": 2,
        "baby_gender": "Male"
      },
      {
        "decade": 1960,
        "births_per_100k": 2,
        "baby_gender": "Male"
      },
      {
        "decade": 1920,
        "births_per_100k": 2,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 1,
        "baby_gender": "Male"
      },
      {
        "decade": 1950,
        "births_per_100k": 0,
        "baby_gender": "Male"
      },
      {
        "decade": 1930,
        "births_per_100k": 0,
        "baby_gender": "Male"
      },
      {
        "decade": 1940,
        "births_per_100k": 0,
        "baby_gender": "Male"
      }
    ]
  },
  {
    "name": "Micheal",
    "total_population": 149601,
    "state_map": [
      {
        "state": "MS",
        "births_per_100k": 232
      },
      {
        "state": "SC",
        "births_per_100k": 190
      },
      {
        "state": "AR",
        "births_per_100k": 185
      },
      {
        "state": "LA",
        "births_per_100k": 180
      },
      {
        "state": "SD",
        "births_per_100k": 179
      },
      {
        "state": "AL",
        "births_per_100k": 175
      },
      {
        "state": "TN",
        "births_per_100k": 174
      },
      {
        "state": "OK",
        "births_per_100k": 170
      },
      {
        "state": "MT",
        "births_per_100k": 163
      },
      {
        "state": "ID",
        "births_per_100k": 157
      },
      {
        "state": "NC",
        "births_per_100k": 156
      },
      {
        "state": "WY",
        "births_per_100k": 155
      },
      {
        "state": "OR",
        "births_per_100k": 151
      },
      {
        "state": "IA",
        "births_per_100k": 149
      },
      {
        "state": "NM",
        "births_per_100k": 149
      },
      {
        "state": "AK",
        "births_per_100k": 149
      },
      {
        "state": "DC",
        "births_per_100k": 147
      },
      {
        "state": "NE",
        "births_per_100k": 146
      },
      {
        "state": "KY",
        "births_per_100k": 138
      },
      {
        "state": "ND",
        "births_per_100k": 138
      },
      {
        "state": "KS",
        "births_per_100k": 133
      },
      {
        "state": "MO",
        "births_per_100k": 132
      },
      {
        "state": "GA",
        "births_per_100k": 132
      },
      {
        "state": "WV",
        "births_per_100k": 131
      },
      {
        "state": "WA",
        "births_per_100k": 130
      },
      {
        "state": "IN",
        "births_per_100k": 114
      },
      {
        "state": "NV",
        "births_per_100k": 112
      },
      {
        "state": "CO",
        "births_per_100k": 111
      },
      {
        "state": "MI",
        "births_per_100k": 111
      },
      {
        "state": "VA",
        "births_per_100k": 110
      },
      {
        "state": "UT",
        "births_per_100k": 99
      },
      {
        "state": "MD",
        "births_per_100k": 96
      },
      {
        "state": "AZ",
        "births_per_100k": 95
      },
      {
        "state": "FL",
        "births_per_100k": 94
      },
      {
        "state": "MN",
        "births_per_100k": 92
      },
      {
        "state": "WI",
        "births_per_100k": 86
      },
      {
        "state": "IL",
        "births_per_100k": 85
      },
      {
        "state": "OH",
        "births_per_100k": 82
      },
      {
        "state": "ME",
        "births_per_100k": 81
      },
      {
        "state": "VT",
        "births_per_100k": 80
      },
      {
        "state": "TX",
        "births_per_100k": 76
      },
      {
        "state": "NH",
        "births_per_100k": 63
      },
      {
        "state": "DE",
        "births_per_100k": 59
      },
      {
        "state": "CA",
        "births_per_100k": 50
      },
      {
        "state": "PA",
        "births_per_100k": 49
      },
      {
        "state": "RI",
        "births_per_100k": 44
      },
      {
        "state": "CT",
        "births_per_100k": 43
      },
      {
        "state": "NY",
        "births_per_100k": 43
      },
      {
        "state": "NJ",
        "births_per_100k": 43
      },
      {
        "state": "MA",
        "births_per_100k": 38
      },
      {
        "state": "HI",
        "births_per_100k": 32
      }
    ],
    "decade_graph": [
      {
        "decade": 1950,
        "births_per_100k": 209,
        "baby_gender": "Male"
      },
      {
        "decade": 1960,
        "births_per_100k": 172,
        "baby_gender": "Male"
      },
      {
        "decade": 1970,
        "births_per_100k": 152,
        "baby_gender": "Male"
      },
      {
        "decade": 1980,
        "births_per_100k": 108,
        "baby_gender": "Male"
      },
      {
        "decade": 1940,
        "births_per_100k": 73,
        "baby_gender": "Male"
      },
      {
        "decade": 1990,
        "births_per_100k": 71,
        "baby_gender": "Male"
      },
      {
        "decade": 2000,
        "births_per_100k": 39,
        "baby_gender": "Male"
      },
      {
        "decade": 1910,
        "births_per_100k": 32,
        "baby_gender": "Male"
      },
      {
        "decade": 2010,
        "births_per_100k": 23,
        "baby_gender": "Male"
      },
      {
        "decade": 1920,
        "births_per_100k": 17,
        "baby_gender": "Male"
      },
      {
        "decade": 1930,
        "births_per_100k": 12,
        "baby_gender": "Male"
      },
      {
        "decade": 2000,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 2,
        "baby_gender": "Female"
      },
      {
        "decade": 1960,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 1950,
        "births_per_100k": 0,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 0,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 0,
        "baby_gender": "Female"
      }
    ]
  },
  {
    "name": "Michaela",
    "total_population": 44588,
    "state_map": [
      {
        "state": "VT",
        "births_per_100k": 227
      },
      {
        "state": "RI",
        "births_per_100k": 217
      },
      {
        "state": "ME",
        "births_per_100k": 182
      },
      {
        "state": "SD",
        "births_per_100k": 179
      },
      {
        "state": "MT",
        "births_per_100k": 160
      },
      {
        "state": "NE",
        "births_per_100k": 157
      },
      {
        "state": "NH",
        "births_per_100k": 139
      },
      {
        "state": "ND",
        "births_per_100k": 119
      },
      {
        "state": "AK",
        "births_per_100k": 115
      },
      {
        "state": "WY",
        "births_per_100k": 110
      },
      {
        "state": "MS",
        "births_per_100k": 109
      },
      {
        "state": "DE",
        "births_per_100k": 107
      },
      {
        "state": "KS",
        "births_per_100k": 105
      },
      {
        "state": "NM",
        "births_per_100k": 101
      },
      {
        "state": "SC",
        "births_per_100k": 98
      },
      {
        "state": "HI",
        "births_per_100k": 98
      },
      {
        "state": "KY",
        "births_per_100k": 98
      },
      {
        "state": "CT",
        "births_per_100k": 95
      },
      {
        "state": "TN",
        "births_per_100k": 94
      },
      {
        "state": "WV",
        "births_per_100k": 90
      },
      {
        "state": "AR",
        "births_per_100k": 89
      },
      {
        "state": "MN",
        "births_per_100k": 88
      },
      {
        "state": "MD",
        "births_per_100k": 88
      },
      {
        "state": "MA",
        "births_per_100k": 84
      },
      {
        "state": "OR",
        "births_per_100k": 82
      },
      {
        "state": "WI",
        "births_per_100k": 82
      },
      {
        "state": "WA",
        "births_per_100k": 81
      },
      {
        "state": "OK",
        "births_per_100k": 79
      },
      {
        "state": "NC",
        "births_per_100k": 79
      },
      {
        "state": "IN",
        "births_per_100k": 75
      },
      {
        "state": "VA",
        "births_per_100k": 74
      },
      {
        "state": "AL",
        "births_per_100k": 72
      },
      {
        "state": "MO",
        "births_per_100k": 71
      },
      {
        "state": "IA",
        "births_per_100k": 70
      },
      {
        "state": "NV",
        "births_per_100k": 68
      },
      {
        "state": "AZ",
        "births_per_100k": 68
      },
      {
        "state": "CO",
        "births_per_100k": 68
      },
      {
        "state": "ID",
        "births_per_100k": 68
      },
      {
        "state": "GA",
        "births_per_100k": 61
      },
      {
        "state": "UT",
        "births_per_100k": 60
      },
      {
        "state": "DC",
        "births_per_100k": 60
      },
      {
        "state": "LA",
        "births_per_100k": 50
      },
      {
        "state": "FL",
        "births_per_100k": 49
      },
      {
        "state": "PA",
        "births_per_100k": 46
      },
      {
        "state": "OH",
        "births_per_100k": 43
      },
      {
        "state": "NJ",
        "births_per_100k": 40
      },
      {
        "state": "IL",
        "births_per_100k": 40
      },
      {
        "state": "MI",
        "births_per_100k": 40
      },
      {
        "state": "TX",
        "births_per_100k": 39
      },
      {
        "state": "NY",
        "births_per_100k": 35
      },
      {
        "state": "CA",
        "births_per_100k": 28
      }
    ],
    "decade_graph": [
      {
        "decade": 1990,
        "births_per_100k": 149,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 84,
        "baby_gender": "Female"
      },
      {
        "decade": 2010,
        "births_per_100k": 52,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 27,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 8,
        "baby_gender": "Female"
      },
      {
        "decade": 1960,
        "births_per_100k": 4,
        "baby_gender": "Female"
      },
      {
        "decade": 1950,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 1940,
        "births_per_100k": 2,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 0,
        "baby_gender": "Male"
      }
    ]
  },
  {
    "name": "Michel",
    "total_population": 7022,
    "state_map": [
      {
        "state": "NH",
        "births_per_100k": 46
      },
      {
        "state": "ME",
        "births_per_100k": 30
      },
      {
        "state": "VT",
        "births_per_100k": 12
      },
      {
        "state": "LA",
        "births_per_100k": 11
      },
      {
        "state": "MS",
        "births_per_100k": 8
      },
      {
        "state": "MA",
        "births_per_100k": 8
      },
      {
        "state": "IN",
        "births_per_100k": 7
      },
      {
        "state": "OK",
        "births_per_100k": 7
      },
      {
        "state": "MO",
        "births_per_100k": 7
      },
      {
        "state": "AR",
        "births_per_100k": 7
      },
      {
        "state": "CA",
        "births_per_100k": 6
      },
      {
        "state": "TN",
        "births_per_100k": 6
      },
      {
        "state": "FL",
        "births_per_100k": 6
      },
      {
        "state": "IA",
        "births_per_100k": 6
      },
      {
        "state": "ID",
        "births_per_100k": 6
      },
      {
        "state": "NY",
        "births_per_100k": 5
      },
      {
        "state": "WA",
        "births_per_100k": 5
      },
      {
        "state": "CO",
        "births_per_100k": 5
      },
      {
        "state": "KY",
        "births_per_100k": 5
      },
      {
        "state": "TX",
        "births_per_100k": 4
      },
      {
        "state": "GA",
        "births_per_100k": 4
      },
      {
        "state": "MI",
        "births_per_100k": 4
      },
      {
        "state": "VA",
        "births_per_100k": 4
      },
      {
        "state": "OR",
        "births_per_100k": 4
      },
      {
        "state": "OH",
        "births_per_100k": 4
      },
      {
        "state": "SC",
        "births_per_100k": 4
      },
      {
        "state": "IL",
        "births_per_100k": 3
      },
      {
        "state": "KS",
        "births_per_100k": 3
      },
      {
        "state": "CT",
        "births_per_100k": 3
      },
      {
        "state": "NC",
        "births_per_100k": 3
      },
      {
        "state": "AL",
        "births_per_100k": 3
      },
      {
        "state": "MN",
        "births_per_100k": 2
      },
      {
        "state": "MD",
        "births_per_100k": 2
      },
      {
        "state": "NJ",
        "births_per_100k": 2
      },
      {
        "state": "WI",
        "births_per_100k": 2
      },
      {
        "state": "PA",
        "births_per_100k": 1
      },
      {
        "state": "AZ",
        "births_per_100k": 1
      }
    ],
    "decade_graph": [
      {
        "decade": 1950,
        "births_per_100k": 9,
        "baby_gender": "Male"
      },
      {
        "decade": 1960,
        "births_per_100k": 8,
        "baby_gender": "Male"
      },
      {
        "decade": 1970,
        "births_per_100k": 6,
        "baby_gender": "Male"
      },
      {
        "decade": 1980,
        "births_per_100k": 6,
        "baby_gender": "Male"
      },
      {
        "decade": 1910,
        "births_per_100k": 4,
        "baby_gender": "Male"
      },
      {
        "decade": 1940,
        "births_per_100k": 4,
        "baby_gender": "Male"
      },
      {
        "decade": 1990,
        "births_per_100k": 4,
        "baby_gender": "Male"
      },
      {
        "decade": 1920,
        "births_per_100k": 3,
        "baby_gender": "Male"
      },
      {
        "decade": 2000,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 1930,
        "births_per_100k": 3,
        "baby_gender": "Male"
      },
      {
        "decade": 1960,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 3,
        "baby_gender": "Male"
      },
      {
        "decade": 1940,
        "births_per_100k": 2,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 2,
        "baby_gender": "Female"
      },
      {
        "decade": 2010,
        "births_per_100k": 1,
        "baby_gender": "Male"
      },
      {
        "decade": 1950,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 2010,
        "births_per_100k": 0,
        "baby_gender": "Female"
      }
    ]
  },
  {
    "name": "Michell",
    "total_population": 4371,
    "state_map": [
      {
        "state": "MS",
        "births_per_100k": 21
      },
      {
        "state": "LA",
        "births_per_100k": 16
      },
      {
        "state": "MO",
        "births_per_100k": 14
      },
      {
        "state": "AR",
        "births_per_100k": 13
      },
      {
        "state": "NV",
        "births_per_100k": 10
      },
      {
        "state": "CO",
        "births_per_100k": 10
      },
      {
        "state": "OK",
        "births_per_100k": 9
      },
      {
        "state": "KY",
        "births_per_100k": 9
      },
      {
        "state": "KS",
        "births_per_100k": 9
      },
      {
        "state": "GA",
        "births_per_100k": 9
      },
      {
        "state": "AL",
        "births_per_100k": 9
      },
      {
        "state": "IN",
        "births_per_100k": 9
      },
      {
        "state": "SC",
        "births_per_100k": 8
      },
      {
        "state": "DC",
        "births_per_100k": 8
      },
      {
        "state": "TX",
        "births_per_100k": 7
      },
      {
        "state": "AZ",
        "births_per_100k": 7
      },
      {
        "state": "FL",
        "births_per_100k": 6
      },
      {
        "state": "CA",
        "births_per_100k": 6
      },
      {
        "state": "WA",
        "births_per_100k": 6
      },
      {
        "state": "NY",
        "births_per_100k": 6
      },
      {
        "state": "OH",
        "births_per_100k": 6
      },
      {
        "state": "IL",
        "births_per_100k": 5
      },
      {
        "state": "MI",
        "births_per_100k": 5
      },
      {
        "state": "MD",
        "births_per_100k": 5
      },
      {
        "state": "PA",
        "births_per_100k": 4
      },
      {
        "state": "NJ",
        "births_per_100k": 4
      },
      {
        "state": "WI",
        "births_per_100k": 4
      },
      {
        "state": "NC",
        "births_per_100k": 4
      },
      {
        "state": "MN",
        "births_per_100k": 3
      },
      {
        "state": "OR",
        "births_per_100k": 3
      },
      {
        "state": "TN",
        "births_per_100k": 3
      },
      {
        "state": "VA",
        "births_per_100k": 2
      },
      {
        "state": "MA",
        "births_per_100k": 2
      },
      {
        "state": "IA",
        "births_per_100k": 2
      }
    ],
    "decade_graph": [
      {
        "decade": 1970,
        "births_per_100k": 13,
        "baby_gender": "Female"
      },
      {
        "decade": 1960,
        "births_per_100k": 7,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 6,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 6,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 5,
        "baby_gender": "Female"
      },
      {
        "decade": 2010,
        "births_per_100k": 2,
        "baby_gender": "Female"
      },
      {
        "decade": 1950,
        "births_per_100k": 0,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 0,
        "baby_gender": "Male"
      },
      {
        "decade": 1990,
        "births_per_100k": 0,
        "baby_gender": "Male"
      }
    ]
  },
  {
    "name": "Michal",
    "total_population": 2165,
    "state_map": [
      {
        "state": "IL",
        "births_per_100k": 8
      },
      {
        "state": "UT",
        "births_per_100k": 8
      },
      {
        "state": "CT",
        "births_per_100k": 5
      },
      {
        "state": "NY",
        "births_per_100k": 4
      },
      {
        "state": "NJ",
        "births_per_100k": 4
      },
      {
        "state": "CO",
        "births_per_100k": 2
      },
      {
        "state": "IA",
        "births_per_100k": 2
      },
      {
        "state": "MD",
        "births_per_100k": 2
      },
      {
        "state": "CA",
        "births_per_100k": 1
      },
      {
        "state": "OH",
        "births_per_100k": 1
      },
      {
        "state": "TX",
        "births_per_100k": 1
      },
      {
        "state": "AL",
        "births_per_100k": 1
      },
      {
        "state": "FL",
        "births_per_100k": 1
      },
      {
        "state": "MO",
        "births_per_100k": 1
      },
      {
        "state": "TN",
        "births_per_100k": 1
      },
      {
        "state": "PA",
        "births_per_100k": 1
      },
      {
        "state": "MA",
        "births_per_100k": 1
      },
      {
        "state": "GA",
        "births_per_100k": 1
      },
      {
        "state": "MI",
        "births_per_100k": 0
      }
    ],
    "decade_graph": [
      {
        "decade": 2010,
        "births_per_100k": 10,
        "baby_gender": "Male"
      },
      {
        "decade": 2000,
        "births_per_100k": 5,
        "baby_gender": "Male"
      },
      {
        "decade": 1990,
        "births_per_100k": 4,
        "baby_gender": "Male"
      },
      {
        "decade": 2010,
        "births_per_100k": 4,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 4,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 2,
        "baby_gender": "Female"
      },
      {
        "decade": 1940,
        "births_per_100k": 2,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 1,
        "baby_gender": "Male"
      },
      {
        "decade": 1950,
        "births_per_100k": 1,
        "baby_gender": "Male"
      },
      {
        "decade": 1960,
        "births_per_100k": 0,
        "baby_gender": "Male"
      },
      {
        "decade": 1950,
        "births_per_100k": 0,
        "baby_gender": "Female"
      },
      {
        "decade": 1960,
        "births_per_100k": 0,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 0,
        "baby_gender": "Male"
      },
      {
        "decade": 1940,
        "births_per_100k": 0,
        "baby_gender": "Male"
      }
    ]
  },
  {
    "name": "Michale",
    "total_population": 966,
    "state_map": [
      {
        "state": "UT",
        "births_per_100k": 4
      },
      {
        "state": "CA",
        "births_per_100k": 3
      },
      {
        "state": "FL",
        "births_per_100k": 2
      },
      {
        "state": "TX",
        "births_per_100k": 2
      },
      {
        "state": "IL",
        "births_per_100k": 2
      },
      {
        "state": "OK",
        "births_per_100k": 2
      },
      {
        "state": "GA",
        "births_per_100k": 1
      },
      {
        "state": "NY",
        "births_per_100k": 1
      },
      {
        "state": "MI",
        "births_per_100k": 1
      },
      {
        "state": "PA",
        "births_per_100k": 1
      },
      {
        "state": "OH",
        "births_per_100k": 1
      },
      {
        "state": "KY",
        "births_per_100k": 1
      },
      {
        "state": "TN",
        "births_per_100k": 1
      },
      {
        "state": "AZ",
        "births_per_100k": 1
      },
      {
        "state": "NC",
        "births_per_100k": 1
      },
      {
        "state": "IN",
        "births_per_100k": 1
      },
      {
        "state": "VA",
        "births_per_100k": 1
      }
    ],
    "decade_graph": [
      {
        "decade": 1980,
        "births_per_100k": 3,
        "baby_gender": "Male"
      },
      {
        "decade": 1970,
        "births_per_100k": 3,
        "baby_gender": "Male"
      },
      {
        "decade": 1950,
        "births_per_100k": 2,
        "baby_gender": "Male"
      },
      {
        "decade": 2010,
        "births_per_100k": 2,
        "baby_gender": "Male"
      },
      {
        "decade": 1960,
        "births_per_100k": 1,
        "baby_gender": "Male"
      },
      {
        "decade": 1990,
        "births_per_100k": 0,
        "baby_gender": "Male"
      }
    ]
  },
  {
    "name": "Michelina",
    "total_population": 892,
    "state_map": [
      {
        "state": "CT",
        "births_per_100k": 9
      },
      {
        "state": "RI",
        "births_per_100k": 9
      },
      {
        "state": "MA",
        "births_per_100k": 8
      },
      {
        "state": "NJ",
        "births_per_100k": 7
      },
      {
        "state": "NY",
        "births_per_100k": 6
      },
      {
        "state": "PA",
        "births_per_100k": 1
      }
    ],
    "decade_graph": [
      {
        "decade": 1920,
        "births_per_100k": 12,
        "baby_gender": "Female"
      },
      {
        "decade": 1910,
        "births_per_100k": 10,
        "baby_gender": "Female"
      },
      {
        "decade": 1930,
        "births_per_100k": 8,
        "baby_gender": "Female"
      },
      {
        "decade": 1940,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 1950,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 1960,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 0,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 0,
        "baby_gender": "Female"
      }
    ]
  },
  {
    "name": "Michaella",
    "total_population": 659,
    "state_map": [
      {
        "state": "MO",
        "births_per_100k": 6
      },
      {
        "state": "MA",
        "births_per_100k": 6
      },
      {
        "state": "WA",
        "births_per_100k": 5
      },
      {
        "state": "FL",
        "births_per_100k": 3
      },
      {
        "state": "NY",
        "births_per_100k": 3
      },
      {
        "state": "UT",
        "births_per_100k": 3
      },
      {
        "state": "IN",
        "births_per_100k": 3
      },
      {
        "state": "OH",
        "births_per_100k": 3
      },
      {
        "state": "NC",
        "births_per_100k": 3
      },
      {
        "state": "CO",
        "births_per_100k": 3
      },
      {
        "state": "NJ",
        "births_per_100k": 2
      },
      {
        "state": "CA",
        "births_per_100k": 2
      },
      {
        "state": "PA",
        "births_per_100k": 2
      },
      {
        "state": "IL",
        "births_per_100k": 2
      },
      {
        "state": "MI",
        "births_per_100k": 2
      },
      {
        "state": "GA",
        "births_per_100k": 1
      },
      {
        "state": "TX",
        "births_per_100k": 1
      }
    ],
    "decade_graph": [
      {
        "decade": 1990,
        "births_per_100k": 4,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 2010,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 1960,
        "births_per_100k": 0,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 0,
        "baby_gender": "Female"
      }
    ]
  },
  {
    "name": "Michela",
    "total_population": 598,
    "state_map": [
      {
        "state": "MA",
        "births_per_100k": 12
      },
      {
        "state": "NJ",
        "births_per_100k": 4
      },
      {
        "state": "NY",
        "births_per_100k": 3
      },
      {
        "state": "CA",
        "births_per_100k": 2
      },
      {
        "state": "PA",
        "births_per_100k": 2
      },
      {
        "state": "IL",
        "births_per_100k": 1
      },
      {
        "state": "FL",
        "births_per_100k": 1
      },
      {
        "state": "OH",
        "births_per_100k": 1
      }
    ],
    "decade_graph": [
      {
        "decade": 1990,
        "births_per_100k": 5,
        "baby_gender": "Female"
      },
      {
        "decade": 2010,
        "births_per_100k": 4,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 2,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 0,
        "baby_gender": "Female"
      },
      {
        "decade": 1940,
        "births_per_100k": 0,
        "baby_gender": "Female"
      }
    ]
  },
  {
    "name": "Michaelene",
    "total_population": 477,
    "state_map": [
      {
        "state": "PA",
        "births_per_100k": 4
      },
      {
        "state": "IL",
        "births_per_100k": 4
      },
      {
        "state": "IA",
        "births_per_100k": 2
      },
      {
        "state": "NJ",
        "births_per_100k": 1
      },
      {
        "state": "IN",
        "births_per_100k": 1
      },
      {
        "state": "MI",
        "births_per_100k": 1
      },
      {
        "state": "OH",
        "births_per_100k": 1
      },
      {
        "state": "NY",
        "births_per_100k": 0
      }
    ],
    "decade_graph": [
      {
        "decade": 1940,
        "births_per_100k": 4,
        "baby_gender": "Female"
      },
      {
        "decade": 1960,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 1950,
        "births_per_100k": 2,
        "baby_gender": "Female"
      },
      {
        "decade": 1930,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 0,
        "baby_gender": "Female"
      }
    ]
  },
  {
    "name": "Michaelangelo",
    "total_population": 467,
    "state_map": [
      {
        "state": "CA",
        "births_per_100k": 3
      },
      {
        "state": "FL",
        "births_per_100k": 1
      },
      {
        "state": "NY",
        "births_per_100k": 1
      },
      {
        "state": "MA",
        "births_per_100k": 1
      },
      {
        "state": "TX",
        "births_per_100k": 1
      },
      {
        "state": "AZ",
        "births_per_100k": 1
      },
      {
        "state": "IL",
        "births_per_100k": 0
      }
    ],
    "decade_graph": [
      {
        "decade": 2010,
        "births_per_100k": 3,
        "baby_gender": "Male"
      },
      {
        "decade": 1990,
        "births_per_100k": 2,
        "baby_gender": "Male"
      },
      {
        "decade": 2000,
        "births_per_100k": 2,
        "baby_gender": "Male"
      },
      {
        "decade": 1980,
        "births_per_100k": 1,
        "baby_gender": "Male"
      },
      {
        "decade": 1970,
        "births_per_100k": 0,
        "baby_gender": "Male"
      }
    ]
  },
  {
    "name": "Michala",
    "total_population": 465,
    "state_map": [
      {
        "state": "NC",
        "births_per_100k": 9
      },
      {
        "state": "OK",
        "births_per_100k": 7
      },
      {
        "state": "MO",
        "births_per_100k": 5
      },
      {
        "state": "NE",
        "births_per_100k": 5
      },
      {
        "state": "VA",
        "births_per_100k": 5
      },
      {
        "state": "TX",
        "births_per_100k": 4
      },
      {
        "state": "MI",
        "births_per_100k": 4
      },
      {
        "state": "OH",
        "births_per_100k": 4
      },
      {
        "state": "GA",
        "births_per_100k": 3
      },
      {
        "state": "PA",
        "births_per_100k": 3
      },
      {
        "state": "IL",
        "births_per_100k": 2
      },
      {
        "state": "KY",
        "births_per_100k": 2
      },
      {
        "state": "MD",
        "births_per_100k": 2
      },
      {
        "state": "TN",
        "births_per_100k": 2
      },
      {
        "state": "LA",
        "births_per_100k": 2
      },
      {
        "state": "IN",
        "births_per_100k": 1
      },
      {
        "state": "CA",
        "births_per_100k": 1
      },
      {
        "state": "MN",
        "births_per_100k": 1
      },
      {
        "state": "WA",
        "births_per_100k": 1
      },
      {
        "state": "NY",
        "births_per_100k": 1
      },
      {
        "state": "FL",
        "births_per_100k": 0
      }
    ],
    "decade_graph": [
      {
        "decade": 1970,
        "births_per_100k": 5,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 4,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 0,
        "baby_gender": "Female"
      }
    ]
  }
]
WITH __stage0 AS (
  SELECT
    group_set,
    (floor(base.year/10))*10 as decade__0,
    base.state as state__0,
    CASE WHEN base.gender='M' THEN 'Male' ELSE 'Female' END as baby_gender__0,
    base.gender as gender__0,
    CASE WHEN group_set=0 THEN SUM(base.number) END as cohort_population__0,
    CASE WHEN group_set=1 THEN base.name END as name__1,
    CASE WHEN group_set=1 THEN SUM(base.number) END as population__1
  FROM `bigquery-public-data.usa_names.usa_1910_2013` as base
  CROSS JOIN (SELECT row_number() OVER() -1  group_set FROM UNNEST(GENERATE_ARRAY(0,1,1)))
  GROUP BY 1,2,3,4,5,7
)
, __stage1 AS (
  SELECT
    decade__0 as decade,
    state__0 as state,
    baby_gender__0 as baby_gender,
    gender__0 as gender,
    ANY_VALUE(CASE WHEN group_set=0 THEN cohort_population__0 END) as cohort_population,
    ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT(name__1 as name, population__1 as population) END IGNORE NULLS  ORDER BY  population__1 desc ) as by_name
  FROM __stage0
  GROUP BY 1,2,3,4
  ORDER BY 5 desc
)
, __stage2 AS (
  SELECT
    group_set,
    concat(by_name_0.name,'') as name__0,
    CASE WHEN group_set=0 THEN SUM(by_name_0.population) END as total_population__0,
    CASE WHEN group_set=1 THEN names.state END as state__1,
    CASE WHEN group_set=1 THEN FLOOR((SUM(by_name_0.population)/CAST((
      (
        SUM(DISTINCT
          (CAST(ROUND(COALESCE(names.cohort_population,0)*(1*1.0), 9) AS NUMERIC) +
          (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001
        ))
        -
         SUM(DISTINCT (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001)
      )/(1*1.0)) as FLOAT64))*100000) END as births_per_100k__1,
    CASE WHEN group_set=2 THEN names.decade END as decade__2,
    CASE WHEN group_set=2 THEN FLOOR((SUM(by_name_0.population)/CAST((
      (
        SUM(DISTINCT
          (CAST(ROUND(COALESCE(names.cohort_population,0)*(1*1.0), 9) AS NUMERIC) +
          (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001
        ))
        -
         SUM(DISTINCT (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001)
      )/(1*1.0)) as FLOAT64))*100000) END as births_per_100k__2,
    CASE WHEN group_set=2 THEN names.baby_gender END as baby_gender__2
  FROM (SELECT GENERATE_UUID() as __distinct_key, * FROM __stage1) as names
  , UNNEST(names.by_name) as by_name_0
  CROSS JOIN (SELECT row_number() OVER() -1  group_set FROM UNNEST(GENERATE_ARRAY(0,2,1)))
  WHERE concat(by_name_0.name,'') LIKE 'Mich%'
  GROUP BY 1,2,4,6,8
)
SELECT
  name__0 as name,
  ANY_VALUE(CASE WHEN group_set=0 THEN total_population__0 END) as total_population,
  ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT(state__1 as state, births_per_100k__1 as births_per_100k) END IGNORE NULLS  ORDER BY  births_per_100k__1 desc ) as state_map,
  ARRAY_AGG(CASE WHEN group_set=2 THEN STRUCT(decade__2 as decade, births_per_100k__2 as births_per_100k, baby_gender__2 as baby_gender) END IGNORE NULLS  ORDER BY  births_per_100k__2 desc ) as decade_graph
FROM __stage2
GROUP BY 1
ORDER BY 2 desc
LIMIT 15

Iconic Names by State and Gender

Calculate the births per 100K for a name in general and a name within a state. Compute and sort by a ratio to figure out relative popularity.

query: names {where: decade <1970}->{
  group_by: name
  group_by: gender
  aggregate: births_per_100k
  nest: by_state is {
    group_by: state
    aggregate: births_per_100k
  }
}
-> {
  where: births_per_100k > 50
  group_by: by_state.state
  nest: by_gender is {
    group_by: gender
    nest: by_name is {
      top: 15
      order_by: 2 desc
      group_by: name
      aggregate: popularity is (by_state.births_per_100k - births_per_100k) /births_per_100k
    }
  }
}
QUERY RESULTS
state by_​gender
AK
gender
F
by_name
name popularity
Daisy 5.229
Shannon 2.506
Lucy 2.389
Sophie 1.934
Deanna 1.841
Tina 1.838
Agnes 1.833
Katherine 1.735
Colleen 1.638
Kristin 1.567
Leslie 1.497
Teresa 1.469
Heather 1.424
Heidi 1.364
Valerie 1.35
gender
M
by_name
name popularity
Shawn 3.153
Jason 2.75
Troy 1.667
Tracy 1.623
Sean 1.562
Peter 1.525
Patrick 1.447
Karl 1.405
Matthew 1.306
Dwayne 1.281
Darren 1.227
Eric 1.203
Mike 1.152
Andrew 1.137
Micheal 1.128
AL
gender
F
by_name
name popularity
Annie 4.751
Willie 3.772
Mattie 3.689
Johnnie 3.338
Rosie 3.034
Shelia 2.987
Katie 2.964
Fannie 2.84
Lillie 2.705
Essie 2.627
Lula 2.536
Minnie 2.412
Hattie 2.318
Mamie 2.301
Susie 2.299
gender
M
by_name
name popularity
Willie 4.273
Charlie 3.119
Earnest 2.676
Jessie 2.612
Johnnie 2.554
Rickey 2.33
Eddie 2.284
Jimmie 2.24
Horace 2.129
Otis 2.1
Jimmy 2.047
Johnny 1.912
Billy 1.825
Bennie 1.793
Nathaniel 1.736
AR
gender
F
by_name
name popularity
Rosie 3.23
Bobbie 2.79
Erma 2.773
Patsy 2.558
Billie 2.486
Ruby 2.28
Velma 2.245
Opal 2.216
Ollie 2.196
Geneva 2.163
Willie 2.117
Essie 1.941
Jessie 1.883
Shelia 1.848
Lola 1.838
gender
M
by_name
name popularity
Rickey 3.636
Billy 3.309
Bobby 3.242
Jimmy 2.905
Jessie 2.49
Earnest 2.426
Freddie 2.321
Tommy 2.281
Jimmie 2.202
Otis 2.15
Jackie 2.138
Bennie 1.897
Luther 1.806
Cecil 1.748
Donnie 1.746
AZ
gender
F
by_name
name popularity
Carmen 5.642
Cecilia 3.719
Maria 3.649
Lupe 3.222
Lydia 3.197
Yolanda 3
Ramona 2.556
Dora 1.956
Guadalupe 1.911
Susie 1.61
Alicia 1.606
Veronica 1.504
Christina 1.492
Rosie 1.471
Monica 1.394
gender
M
by_name
name popularity
Manuel 8.982
Ruben 5.639
Francisco 5
Carlos 4.418
Jesus 4.333
Jose 3.599
Gilbert 3.48
Antonio 3.464
Raul 3.145
Alex 3.078
Hector 2.962
Miguel 2.722
Juan 2.449
Luis 2.353
Woodrow 2.058
CA
gender
F
by_name
name popularity
Christina 1.358
Carmen 1.347
Yolanda 1.257
Teri 1.06
Maria 1.006
Pat 0.907
Cecilia 0.877
Leslie 0.848
Julie 0.837
Victoria 0.829
Monica 0.78
Ramona 0.764
Alicia 0.727
Lydia 0.724
Shannon 0.718
gender
M
by_name
name popularity
Manuel 2.327
Ruben 2
Carlos 1.456
Mario 1.231
Mike 1.196
Jason 1.069
Bob 1.036
Lance 0.982
Gilbert 0.967
Jim 0.965
Dave 0.882
Jose 0.86
Ricardo 0.855
Eric 0.829
Chris 0.824
CO
gender
F
by_name
name popularity
Kristi 1.962
Shelly 1.368
Olive 1.269
Bernadette 1.211
Ramona 1.194
Becky 1.101
Nicole 1.091
Heather 1.082
Della 1.053
Heidi 1.03
Erma 1.015
Dianna 1.015
Karla 0.968
Kelli 0.964
Tamara 0.91
gender
M
by_name
name popularity
Kent 1.986
Manuel 1.636
Kirk 1.606
Woodrow 1.558
Gilbert 1.374
Kelly 1.347
Brett 1.288
Bob 1.205
Shawn 1.119
Delbert 1.109
Rick 1.104
Mike 1.07
Jason 1.028
Joe 0.985
Dave 0.971
CT
gender
F
by_name
name popularity
Sophie 2.656
Doreen 2.646
Claire 1.772
Lynn 1.664
Gail 1.564
Antoinette 1.526
Kristen 1.509
Maureen 1.483
Maryann 1.461
Laurie 1.408
Marion 1.343
Jennie 1.258
Heather 1.188
Anne 1.143
Lynne 1.11
gender
M
by_name
name popularity
Peter 2.449
Nicholas 1.984
Salvatore 1.933
Jonathan 1.737
Angelo 1.625
Francis 1.475
Alexander 1.353
Vincent 1.269
Marc 1.171
Frederick 1.153
Sean 1.132
Anthony 1.022
Louis 0.966
Joseph 0.908
Theodore 0.841
DC
gender
F
by_name
name popularity
Cassandra 2.019
Crystal 2.017
Yvette 1.867
Tonya 1.833
Tanya 1.719
Gwendolyn 1.559
Leslie 1.406
Jacqueline 1.368
Delores 1.331
Laverne 1.327
Renee 1.319
Vanessa 1.316
Nicole 1.291
Monica 1.257
Yvonne 1.253
gender
M
by_name
name popularity
Tyrone 5.263
Reginald 3.785
Derrick 2.627
Maurice 1.908
Ricardo 1.764
Derek 1.736
Darryl 1.693
Dwayne 1.688
Nathaniel 1.417
Jonathan 1.331
Sean 1.231
Eric 1.219
Clifton 1.167
Bernard 1.093
Christopher 1
DE
gender
F
by_name
name popularity
Crystal 3.397
Sophie 2.869
Mabel 2.578
Stella 2.339
Hilda 2.325
Heather 2.129
Elsie 2.097
Pearl 1.839
Nicole 1.836
Agnes 1.68
Holly 1.589
Kristin 1.582
Olive 1.519
Dawn 1.516
Blanche 1.449
gender
M
by_name
name popularity
Woodrow 3.981
Francis 2.381
Sean 1.421
Matthew 1.257
Tyrone 1.246
Harry 1.212
Christopher 1.165
Roland 1.158
Franklin 1.139
Dwayne 1.063
Horace 1.048
Willard 1.047
Wayne 1.04
Bryan 1.026
Jonathan 0.907
FL
gender
F
by_name
name popularity
Cassandra 1.704
Gwendolyn 1.534
Jacquelyn 1.323
Rosa 1.043
Essie 0.98
Belinda 0.967
Ernestine 0.909
Annie 0.869
Tina 0.829
Daisy 0.829
Johnnie 0.824
Iris 0.821
Angela 0.821
Willie 0.772
Inez 0.743
gender
M
by_name
name popularity
Nathaniel 2.236
Freddie 1.744
Willie 1.714
Johnnie 1.438
Reginald 1.367
Horace 1.177
Eddie 1.096
Charlie 0.902
Derrick 0.896
Johnny 0.839
Jimmie 0.837
Dwayne 0.766
Tyrone 0.754
Earnest 0.75
Otis 0.717
GA
gender
F
by_name
name popularity
Annie 3.997
Mattie 3.763
Willie 3.178
Essie 3.098
Mamie 3.027
Johnnie 2.73
Susie 2.494
Fannie 2.444
Lillie 2.409
Hattie 2.282
Katie 2.25
Sara 2.183
Rosa 2.173
Daisy 2.071
Lucile 2.068
gender
M
by_name
name popularity
Charlie 4.636
Willie 4.57
Horace 3.081
Otis 2.733
Bennie 2.483
Johnnie 2.438
Eddie 2.391
Freddie 2.115
Nathaniel 2.083
Earnest 2.074
Johnny 2.04
Marion 1.813
Hugh 1.772
Hubert 1.769
Luther 1.746
HI
gender
F
by_name
name popularity
Kiyoko 6.807
Yoshiko 6.404
Masako 5.984
Fumiko 5.911
Mitsue 5.868
Shizue 4.775
Roxanne 4.723
Bernadette 4.579
Yoshie 4.027
Kikue 3.966
Shizuko 3.963
Iris 3.893
Mitsuko 3.888
Violet 3.632
Doreen 3.415
gender
M
by_name
name popularity
Toshio 7.902
Yoshio 7.897
Kiyoshi 6.985
Kazuo 6.444
Lance 6.089
Minoru 5.981
Derek 5.962
Takeo 4.956
Jason 4.806
Clayton 4.39
Shigeo 4.311
Nathan 3.952
Guy 3.588
Wendell 3.208
Sean 3.017
IA
gender
F
by_name
name popularity
Becky 1.927
Karla 1.921
Maxine 1.826
Shelly 1.821
Kristi 1.577
Julie 1.523
Jodi 1.443
Sheryl 1.403
Marcella 1.339
Connie 1.327
Erma 1.288
Tami 1.286
Jody 1.269
Kristine 1.227
Roxanne 1.108
gender
M
by_name
name popularity
Lyle 3.762
Duane 2.508
Kent 2.157
Dean 2.096
Woodrow 1.788
Darin 1.774
Max 1.685
Bradley 1.61
Rick 1.584
Delbert 1.564
Virgil 1.474
Dale 1.471
Lynn 1.45
Jon 1.448
Rex 1.439
ID
gender
F
by_name
name popularity
Olive 3.808
Karla 3.206
Heather 2.918
Shannon 2.812
Shelley 2.73
Kristi 2.558
Maxine 2.53
Becky 2.468
Blanche 2.359
Tamara 2.342
Robyn 2.17
Tami 2.159
Jody 2.119
Opal 2.093
Shelly 2.019
gender
M
by_name
name popularity
Kelly 5.944
Brent 5.585
Darin 5.453
Lynn 5.183
Woodrow 4.231
Kim 3.879
Kent 3.843
Lyle 3.413
Rex 3.351
Max 2.973
Tracy 2.82
Brett 2.493
Brad 2.474
Delbert 2.4
Rick 2.264
IL
gender
F
by_name
name popularity
Laverne 1.273
Dolores 0.667
Genevieve 0.622
Rosemary 0.612
Lorraine 0.606
Marcella 0.581
Pat 0.556
Marianne 0.5
Marilyn 0.461
Judith 0.416
Loretta 0.383
Arlene 0.37
Eileen 0.354
Bernice 0.348
Kristine 0.341
gender
M
by_name
name popularity
Jerome 0.604
Derrick 0.537
Tyrone 0.474
Maurice 0.429
Bradley 0.366
Tom 0.336
Lyle 0.333
Brad 0.295
Chester 0.273
Patrick 0.264
Kurt 0.256
Lawrence 0.252
Bob 0.25
Martin 0.248
Darryl 0.248
IN
gender
F
by_name
name popularity
Tamara 1.351
Patty 1.193
Tina 1.15
Wilma 1.017
Penny 0.969
Beth 0.96
Marsha 0.952
Olive 0.942
Sue 0.937
Lana 0.922
Dianna 0.912
Tonya 0.822
Marcia 0.814
Rebecca 0.755
Cathy 0.752
gender
M
by_name
name popularity
Max 2.37
Rex 1.93
Kent 1.371
Rick 1.28
Brent 1.134
Bradley 1.033
Jeffery 0.967
Jeff 0.947
Tim 0.946
Wilbur 0.905
Darrin 0.885
Kerry 0.879
Darin 0.868
Garry 0.833
Terry 0.754
KS
gender
F
by_name
name popularity
Karla 2.111
Kristi 1.923
Maxine 1.811
Shelly 1.792
Wilma 1.73
Opal 1.557
Deanna 1.449
Connie 1.414
Velma 1.392
Lana 1.373
Lola 1.294
Dana 1.268
Beulah 1.233
Dianna 1.221
Sheryl 1.202
gender
M
by_name
name popularity
Darin 3.528
Max 2.452
Rex 2.281
Delbert 2.2
Kelly 2.167
Virgil 2.013
Lyle 1.984
Kent 1.914
Bradley 1.634
Brad 1.526
Bob 1.375
Brent 1.329
Duane 1.234
Everett 1.231
Marion 1.213
KY
gender
F
by_name
name popularity
Geneva 2.827
Della 2.07
Opal 1.959
Shelia 1.797
Wilma 1.753
Beulah 1.616
Ruby 1.472
Wanda 1.425
Vickie 1.357
Ada 1.348
Alma 1.273
Nora 1.2
Myrtle 1.183
Thelma 1.103
Eula 1.097
gender
M
by_name
name popularity
Donnie 3.343
Jackie 2.255
Wendell 1.792
Homer 1.729
Virgil 1.718
Cecil 1.687
Ronnie 1.646
Bobby 1.596
Billy 1.596
Hubert 1.538
Garry 1.5
Everett 1.462
Willard 1.365
Danny 1.364
Chester 1.32
LA
gender
F
by_name
name popularity
Shelia 2.582
Irma 1.824
Eula 1.758
Rosie 1.713
Vanessa 1.663
Gwendolyn 1.619
Mable 1.54
Lillie 1.436
Hilda 1.373
Bobbie 1.31
Glenda 1.306
Ella 1.302
Willie 1.284
Cassandra 1.241
Paulette 1.217
gender
M
by_name
name popularity
Sidney 2.385
Clifton 2.25
Freddie 2.231
Alvin 2.071
Jessie 1.939
Dwayne 1.719
Willie 1.635
Tyrone 1.491
Oliver 1.49
Kerry 1.466
Herman 1.43
Earnest 1.412
Calvin 1.401
Byron 1.358
Rickey 1.307
MA
gender
F
by_name
name popularity
Claire 5.013
Maureen 3.058
Priscilla 2.288
Lynne 1.857
Jeannette 1.779
Anne 1.585
Joanne 1.524
Doreen 1.477
Eleanor 1.475
Muriel 1.418
Sophie 1.393
Marion 1.29
Jeanne 1.283
Eileen 1.282
Lorraine 1.236
gender
M
by_name
name popularity
Francis 2.843
Peter 2.057
Gerard 2
Dana 1.87
Roland 1.642
Leo 1.503
Frederick 1.281
Stephen 1.266
Philip 1.186
Paul 1.179
Jonathan 1.144
Alfred 1.028
Sean 0.942
Arthur 0.903
Joseph 0.856
MD
gender
F
by_name
name popularity
Crystal 1.655
Hilda 1.325
Vanessa 1.306
Yvette 1.217
Robin 1.016
Darlene 0.888
Rosalie 0.887
Bernadette 0.825
Dawn 0.814
Terry 0.803
Catherine 0.801
Tracey 0.761
Regina 0.75
Naomi 0.75
Michele 0.749
gender
M
by_name
name popularity
Tyrone 2.07
Dwayne 1.484
Roland 1.211
Reginald 1.127
Clifton 1.117
Bernard 1.07
Maurice 0.969
Franklin 0.869
Melvin 0.861
Milton 0.86
Vernon 0.84
Jerome 0.832
Harry 0.803
Nelson 0.732
Darrin 0.731
ME
gender
F
by_name
name popularity
Priscilla 4.3
Jeannette 3.632
Muriel 3.313
Olive 2.654
Claire 2.506
Constance 2.284
Pauline 2.265
Madeline 2.067
Laurie 1.942
Rachel 1.85
Debora 1.667
Kristen 1.623
Marguerite 1.611
Heidi 1.576
Tina 1.529
gender
M
by_name
name popularity
Dana 7.278
Roland 6.505
Woodrow 4.308
Gerard 3.722
Maurice 3.622
Clayton 2.864
Reginald 2.633
Everett 2.359
Troy 2.141
Philip 2.01
Adam 1.963
Normand 1.852
Marc 1.714
Leo 1.693
Shawn 1.619
MI
gender
F
by_name
name popularity
Sally 0.76
Dawn 0.74
Colleen 0.652
Sue 0.626
Julie 0.616
Marcia 0.603
Kay 0.579
Genevieve 0.578
Kelly 0.556
Suzanne 0.528
Marlene 0.513
Michelle 0.491
Renee 0.488
Sheryl 0.476
Shelly 0.462
gender
M
by_name
name popularity
Duane 1.065
Gerald 0.939
Kim 0.862
Gordon 0.855
Dave 0.824
Lyle 0.81
Rick 0.784
Darrin 0.731
Dale 0.692
Fredrick 0.673
Kurt 0.616
Kirk 0.606
Douglas 0.556
Dennis 0.534
Tim 0.514
MN
gender
F
by_name
name popularity
Jodi 2.545
Jody 2.075
Marcella 2
Kristin 1.866
Roxanne 1.862
Kristine 1.716
Kristi 1.712
Colleen 1.553
Harriet 1.542
Julie 1.472
Lorraine 1.407
Heidi 1.394
Delores 1.324
Shelly 1.321
Marlene 1.256
gender
M
by_name
name popularity
Lyle 3.079
Duane 2.919
Bradley 2.675
Jerome 1.96
Dean 1.955
Jason 1.889
Darin 1.623
Gordon 1.62
Todd 1.536
Jon 1.469
Troy 1.43
Dale 1.399
Arnold 1.366
Allan 1.294
Scott 1.268
MO
gender
F
by_name
name popularity
Wilma 1.471
Opal 1.155
Laverne 1.073
Velma 0.931
Marcella 0.855
Lana 0.824
Christy 0.804
Beulah 0.756
Carla 0.745
Shelly 0.736
Glenda 0.729
Georgia 0.719
Norma 0.717
Erma 0.712
Marsha 0.644
gender
M
by_name
name popularity
Virgil 1.397
Darin 1.113
Bob 1.045
Jackie 1.021
Everett 0.91
Delbert 0.909
Bill 0.847
Elmer 0.803
Garry 0.7
Vernon 0.686
Lloyd 0.676
Floyd 0.667
Oliver 0.667
Billy 0.641
Marion 0.6
MS
gender
F
by_name
name popularity
Rosie 8.402
Annie 5.016
Willie 4.904
Bobbie 4.2
Maggie 4.078
Mattie 4.052
Katie 4.036
Lillie 4
Hattie 3.988
Essie 3.902
Johnnie 3.824
Lula 3.738
Fannie 3.42
Minnie 3.176
Jessie 3.039
gender
M
by_name
name popularity
Willie 6.282
Jessie 5.602
Johnnie 4.339
Eddie 3.863
Earnest 3.794
Jimmie 3.744
Charlie 3.734
Bennie 3.569
Clifton 2.85
Otis 2.8
Luther 2.373
Sam 2.349
Freddie 2.192
Johnny 1.96
Lee 1.813
MT
gender
F
by_name
name popularity
Tami 2.683
Mabel 2.667
Pat 2.593
Jamie 2.521
Shelly 2.5
Teri 2.418
Olive 2.385
Karla 2.302
Kristi 2.192
Patti 2.119
Genevieve 2.1
Colleen 1.929
Shannon 1.906
Shelley 1.899
Marlene 1.782
gender
M
by_name
name popularity
Kelly 3
Lyle 2.714
Shawn 2.407
Woodrow 2.288
Brett 2.137
Jason 1.972
Brad 1.949
Darin 1.925
Duane 1.887
Darren 1.814
Kirk 1.761
Dan 1.722
Tim 1.676
Lance 1.625
Rick 1.608
NC
gender
F
by_name
name popularity
Annie 3.016
Maggie 2.313
Katie 2.143
Hattie 2.129
Mamie 1.973
Sadie 1.893
Mable 1.667
Lillie 1.604
Shelia 1.557
Rosa 1.554
Fannie 1.469
Hilda 1.458
Rachel 1.425
Crystal 1.414
Daisy 1.4
gender
M
by_name
name popularity
Charlie 2.706
Clifton 2.2
Bobby 2.018
Hubert 1.969
Luther 1.955
Johnnie 1.688
Donnie 1.687
Horace 1.645
Clyde 1.424
Claude 1.418
Willie 1.374
Johnny 1.372
Ricky 1.286
Jimmy 1.266
Marshall 1.197
ND
gender
F
by_name
name popularity
Kristi 6.346
Karla 5.429
Violet 4.057
Myrtle 3.603
Shelly 3.472
Viola 3.297
Roxanne 3.277
Jodi 3.136
Marlene 3.135
Paulette 3.043
Olga 2.853
Hilda 2.831
Olive 2.692
Leona 2.651
Delores 2.615
gender
M
by_name
name popularity
Lyle 6.333
Darin 6.132
Troy 5.985
Duane 5.839
Kelly 3.625
Brent 3.305
Darren 3.206
Bradley 2.992
Lynn 2.967
Jason 2.833
Arnold 2.554
Gordon 2.53
Vernon 2.526
Kim 2.483
Dean 2.436
NE
gender
F
by_name
name popularity
Kristi 3.192
Opal 2.742
Erma 2.197
Maxine 2.023
Shelly 1.934
Jody 1.522
Tami 1.492
Jodi 1.409
Julie 1.408
Olive 1.404
Leona 1.377
Wilma 1.356
Kay 1.306
Deanna 1.243
Christy 1.235
gender
M
by_name
name popularity
Lyle 4.524
Duane 2.46
Darin 2.377
Kent 2.186
Dean 1.814
Dale 1.805
Bradley 1.805
Delbert 1.709
Virgil 1.641
Rex 1.632
Troy 1.607
Lynn 1.55
Kirk 1.493
Rick 1.408
Kelly 1.403
NH
gender
F
by_name
name popularity
Kristen 6.698
Claire 6.203
Jeannette 4.926
Priscilla 4.863
Heidi 3.889
Blanche 3.808
Muriel 3.612
Olive 3.385
Pauline 3.313
Nicole 2.745
Kristin 2.597
Sophie 2.508
Stella 2.492
Lorraine 2.175
Gertrude 2.161
gender
M
by_name
name popularity
Roland 7.726
Maurice 6.01
Gerard 5.153
Dana 4.426
Marc 3.181
Leo 2.687
Normand 2.309
Shawn 2.153
Jonathan 2.136
Peter 1.978
Norman 1.958
Roger 1.828
Jason 1.625
Bruce 1.492
Scott 1.343
NJ
gender
F
by_name
name popularity
Maryann 2.276
Claire 1.873
Eileen 1.578
Antoinette 1.526
Angelina 1.51
Rosemarie 1.418
Madeline 1.28
Maureen 1.267
Marianne 1.214
Michele 1.148
Doreen 1.138
Joan 1.03
Eleanor 0.993
Marion 0.971
Sophie 0.967
gender
M
by_name
name popularity
Nicholas 2.146
Angelo 1.911
Vincent 1.671
Peter 1.492
Salvatore 1.315
Alexander 1.294
Anthony 1.23
Gerard 1.167
Joseph 1.148
Frank 0.95
Louis 0.931
Frederick 0.803
Edward 0.785
Theodore 0.785
Andrew 0.701
NM
gender
F
by_name
name popularity
Cecilia 6.018
Ramona 4.694
Carmen 4.421
Bernadette 3.965
Maria 3.782
Lucy 3.588
Priscilla 3.563
Flora 2.953
Yolanda 2.771
Dora 2.67
Marcella 2.645
Lydia 2.421
Lupe 2.222
Stella 2.161
Rosie 2.103
gender
M
by_name
name popularity
Manuel 10.227
Jose 7.425
Antonio 5.476
Gilbert 5.228
Ruben 5.016
Juan 4.85
Carlos 4.291
Joe 3.833
Pedro 2.887
Luis 2.776
Alex 2.766
Francisco 2.75
Miguel 2.741
Jesus 2.667
Bennie 2.517
NV
gender
F
by_name
name popularity
Olga 5.103
Traci 4.339
Shannon 4.2
Stacey 4.148
Pat 3.981
Toni 3.165
Natalie 3.15
Teri 3.015
Kelli 2.982
Marguerite 2.947
Tina 2.888
Blanche 2.795
Tami 2.746
Nicole 2.745
Leslie 2.673
gender
M
by_name
name popularity
Jason 4.403
Shawn 4.144
Troy 4.015
Kelly 3.736
Woodrow 3.654
Lance 2.982
Darren 2.711
Mike 2.526
Brent 2
Adam 2
Brett 1.986
Aaron 1.973
Darin 1.943
Delbert 1.891
Tracy 1.639
NY
gender
F
by_name
name popularity
Antoinette 1.756
Eileen 1.675
Madeline 1.653
Miriam 1.618
Muriel 1.567
Angelina 1.549
Rosemarie 1.463
Maureen 1.355
Maryann 1.158
Marion 1
Josephine 1
Claire 0.987
Anne 0.987
Joan 0.915
Doreen 0.908
gender
M
by_name
name popularity
Salvatore 2.258
Angelo 2.054
Vincent 1.963
Nicholas 1.797
Gerard 1.792
Peter 1.687
Stuart 1.21
Anthony 1.184
Seymour 1.13
Alexander 1.035
Martin 0.915
Neil 0.908
Philip 0.89
Louis 0.849
Sidney 0.846
OH
gender
F
by_name
name popularity
Beth 0.678
Patty 0.651
Sue 0.638
Amy 0.591
Marcella 0.5
Dianna 0.456
Becky 0.45
Tonya 0.433
Kimberly 0.422
Rosemary 0.406
Marcia 0.397
Darla 0.397
Penny 0.394
Sandy 0.392
Marilyn 0.39
gender
M
by_name
name popularity
Rick 0.776
Tim 0.703
Dave 0.662
Dale 0.597
Wilbur 0.587
Darrin 0.519
Jeffrey 0.499
Tom 0.493
Timothy 0.484
Jeffery 0.475
Jeff 0.43
Ted 0.41
Karl 0.369
Carl 0.356
Dwight 0.351
OK
gender
F
by_name
name popularity
Opal 4.134
Billie 3.706
Shelly 2.406
Velma 2.196
Kristi 2.192
Patsy 2.154
Darla 2.138
Wanda 2.114
Wilma 1.931
Geneva 1.786
Lola 1.765
Juanita 1.704
Erma 1.682
Kelli 1.655
Ruby 1.609
gender
M
by_name
name popularity
Billy 3.135
Jackie 2.713
Jimmie 2.543
Jimmy 2.38
Tommy 2.292
Bill 2.243
Cecil 2.148
Bobby 2.11
Delbert 2.036
Bob 1.964
Virgil 1.821
Floyd 1.752
Rickey 1.67
Don 1.535
Ronnie 1.472
OR
gender
F
by_name
name popularity
Tami 3.095
Shannon 2.647
Shelley 1.944
Julie 1.912
Kristi 1.904
Tamara 1.883
Lucile 1.695
Shelly 1.679
Jan 1.557
Becky 1.477
Deanna 1.449
Kelli 1.436
Teri 1.433
Karla 1.413
Traci 1.371
gender
M
by_name
name popularity
Darin 2.981
Woodrow 2.75
Kelly 2.583
Rick 2.16
Jason 2.028
Jim 1.849
Bob 1.786
Dan 1.73
Dave 1.618
Brad 1.603
Delbert 1.6
Jeff 1.589
Mike 1.557
Lyle 1.524
Bradley 1.512
PA
gender
F
by_name
name popularity
Anna 1.388
Dolores 1.13
Maryann 1.053
Eleanor 0.979
Miriam 0.974
Bernadette 0.965
Marian 0.748
Sophie 0.738
Rosemarie 0.716
Agnes 0.7
Helen 0.692
Florence 0.687
Stella 0.627
Joanne 0.622
Marianne 0.6
gender
M
by_name
name popularity
Francis 1.395
Harry 1.147
Joseph 1.013
Nicholas 0.919
Barry 0.713
Bernard 0.668
Vincent 0.598
Edward 0.595
Andrew 0.556
Samuel 0.552
Theodore 0.528
Alexander 0.482
Albert 0.463
Stanley 0.452
Frank 0.441
RI
gender
F
by_name
name popularity
Claire 7.051
Kristen 4.245
Muriel 4.164
Angelina 4.098
Doreen 3.415
Maureen 3.221
Jeannette 3.015
Madeline 2.493
Flora 2.313
Jennie 2.289
Gertrude 2.208
Laurie 2.103
Gail 2.011
Olga 1.971
Sophie 1.951
gender
M
by_name
name popularity
Roland 4.263
Gerard 3.167
Normand 2.901
Angelo 2.357
Leo 2.307
Marc 2.286
Alfred 1.968
Peter 1.893
Manuel 1.818
Raymond 1.766
Francis 1.642
Maurice 1.551
Vincent 1.521
Antonio 1.476
Anthony 1.32
SC
gender
F
by_name
name popularity
Hattie 4.224
Rosa 4.094
Maggie 3.984
Janie 3.949
Annie 3.816
Mamie 3.753
Daisy 3.543
Lillie 3.51
Sadie 3.125
Carrie 3.114
Essie 2.804
Lula 2.69
Mattie 2.63
Willie 2.406
Jessie 2.266
gender
M
by_name
name popularity
Marion 4.888
Nathaniel 4.375
Willie 3.948
Woodrow 2.827
Luther 2.716
Johnnie 2.589
Julius 2.571
Leroy 2.507
Charlie 2.399
Bennie 2.345
Freddie 2.154
Otis 2.133
Horace 2.081
Ben 1.761
Benjamin 1.748
SD
gender
F
by_name
name popularity
Kristi 4.404
Karla 3.937
Darla 3.362
Tamara 2.775
Jody 2.612
Violet 2.566
Mabel 2.559
Kay 2.512
Delores 2.439
Maxine 2.348
Verna 2.284
Viola 2.281
Olive 2.173
Leona 2.17
Lana 2.078
gender
M
by_name
name popularity
Lyle 7.286
Darin 4.962
Kelly 4.236
Duane 4.089
Bradley 3.211
Brad 2.641
Troy 2.556
Todd 2.431
Delbert 2.364
Dean 2.301
Dale 2.231
Elmer 1.909
Daryl 1.897
Kim 1.862
Virgil 1.859
TN
gender
F
by_name
name popularity
Shelia 2.772
Bobbie 1.82
Wilma 1.569
Ruby 1.562
Patsy 1.538
Billie 1.477
Mattie 1.452
Glenda 1.403
Geneva 1.398
Willie 1.391
Maggie 1.375
Melissa 1.251
Wanda 1.229
Tonya 1.211
Johnnie 1.203
gender
M
by_name
name popularity
Billy 2.384
Jackie 2.266
Bobby 2.214
Rickey 2.011
Donnie 1.97
Jimmy 1.905
Ronnie 1.717
Hubert 1.6
Luther 1.597
Claude 1.538
Tommy 1.503
Johnny 1.482
Ricky 1.479
Hugh 1.405
Charlie 1.28
TX
gender
F
by_name
name popularity
Maria 5.032
Guadalupe 2.744
Yolanda 2.695
Billie 2.495
Irma 2.365
Rosa 2.338
Alicia 2.303
Janie 2.179
Dora 1.835
Olga 1.779
Bobbie 1.6
Patsy 1.596
Carmen 1.589
Lydia 1.579
Juanita 1.552
gender
M
by_name
name popularity
Juan 5.606
Jose 4.903
Ruben 4.508
Manuel 4.036
Jesus 3.765
Pedro 3.677
Ricardo 3.527
Raul 3.493
Roberto 3.486
Carlos 3.316
Francisco 3.309
Antonio 3.274
Hector 2.528
Guadalupe 2.477
Joe 2.128
UT
gender
F
by_name
name popularity
Robyn 5.604
Sherrie 4.569
Kristine 3.341
Erma 3.182
Natalie 3.167
Becky 3.028
Colleen 3.014
Jan 2.962
Julie 2.744
Jody 2.373
Heidi 2.293
Lucile 2.22
Leslie 2.176
Teri 2.104
Shelly 2.094
gender
M
by_name
name popularity
Brent 10.183
Lynn 9
Kent 7.171
Kelly 7.111
Kim 5.931
Darin 5.528
Woodrow 5.365
Brad 4.487
Max 4.123
Troy 4.03
Rex 3.93
Tracy 3.246
Kerry 3.034
Don 2.979
Jay 2.955
VA
gender
F
by_name
name popularity
Nannie 1.721
Vanessa 1.51
Rosa 1.331
Shelia 1.329
Lucy 1.229
Fannie 1.062
Elsie 1.055
Susie 1.052
Thelma 0.97
Hattie 0.965
Iris 0.964
Nellie 0.962
Angela 0.928
Virginia 0.92
Estelle 0.909
gender
M
by_name
name popularity
Charlie 1.762
Clifton 1.683
Claude 1.626
Lewis 1.472
Luther 1.403
Calvin 1.238
Earnest 1.191
Otis 1.183
Marshall 1.115
Cecil 1.113
Nelson 1.089
Reginald 1.051
Franklin 1.033
Woodrow 1.019
Clarence 0.974
VT
gender
F
by_name
name popularity
Madeline 4.8
Marion 4.135
Laurie 4.013
Blanche 3.936
Claire 3.481
Olive 3
Priscilla 2.913
Heather 2.835
Heidi 2.737
Pauline 2.277
Penny 2.276
Marguerite 2.274
Muriel 2.269
Tina 2.246
Jeannette 2.162
gender
M
by_name
name popularity
Jason 4.125
Reginald 3.696
Maurice 3.694
Roland 3.379
Dana 3.315
Wendell 2.66
Francis 2.639
Bernard 2.495
Gordon 2.452
Everett 2.244
Shawn 2.144
Sean 2.124
Clayton 2
Kim 1.793
Todd 1.763
WA
gender
F
by_name
name popularity
Tami 2.968
Shannon 2.2
Kristi 1.788
Heidi 1.707
Olive 1.673
Shelley 1.663
Kelli 1.655
Colleen 1.645
Kristine 1.5
Teri 1.388
Pat 1.259
Tamara 1.234
Gayle 1.15
Julie 1.133
Deanna 1.121
gender
M
by_name
name popularity
Kelly 2.236
Woodrow 2.192
Rick 2.04
Dave 1.956
Bob 1.929
Jim 1.849
Dan 1.765
Jason 1.667
Jeff 1.629
Mike 1.57
Brad 1.359
Gordon 1.355
Greg 1.355
Bill 1.28
Jon 1.214
WI
gender
F
by_name
name popularity
Kristine 2.83
Laverne 2.473
Jodi 1.795
Marcella 1.726
Kristin 1.328
Lynn 1.327
Sophie 1.279
Kay 1.231
Julie 1.157
Jody 1.134
Lorraine 1.077
Violet 1.057
Jill 1.034
Arlene 1.012
Audrey 0.946
gender
M
by_name
name popularity
Jerome 2.107
Lyle 2.032
Todd 1.807
Duane 1.637
Dean 1.385
Kurt 1.384
Gordon 1.217
Dale 1.153
Jon 1.131
Allan 1.129
Gerald 1.09
Scott 1.08
Arnold 0.92
Gregg 0.882
Jeffrey 0.807
WV
gender
F
by_name
name popularity
Patty 2.241
Opal 1.969
Dianna 1.779
Beulah 1.779
Violet 1.774
Mabel 1.676
Naomi 1.607
Nellie 1.481
Della 1.386
Tammy 1.354
Wilma 1.345
Sherri 1.151
Nina 1.138
Thelma 1.122
Maxine 1.053
gender
M
by_name
name popularity
Jackie 2.606
Delbert 2.2
Homer 2.043
Franklin 2
Woodrow 1.654
Cecil 1.652
Virgil 1.59
Willard 1.424
Everett 1.282
Dana 1.259
Clyde 1.185
Roger 1.109
Danny 1.036
Luther 1.015
Lewis 1.007
WY
gender
F
by_name
name popularity
Pat 3.074
Shannon 2.894
Becky 2.798
Shelley 2.551
Natalie 2.483
Jody 2.418
Jamie 2.366
Stacy 2.313
Agnes 2.267
Shelly 2.104
Violet 2.094
Olive 2
Laurie 1.982
Hazel 1.974
Opal 1.928
gender
M
by_name
name popularity
Troy 5.941
Jason 4.431
Kelly 3.736
Kim 3.552
Brad 3.09
Kent 2.957
Woodrow 2.596
Brett 2.548
Lance 2.536
Bob 2.277
Darin 2.038
Jim 1.959
Bill 1.693
Darren 1.67
Bradley 1.659
[
  {
    "state": "AK",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Daisy",
            "popularity": 5.228571428571429
          },
          {
            "name": "Shannon",
            "popularity": 2.5058823529411764
          },
          {
            "name": "Lucy",
            "popularity": 2.3893129770992365
          },
          {
            "name": "Sophie",
            "popularity": 1.9344262295081966
          },
          {
            "name": "Deanna",
            "popularity": 1.841121495327103
          },
          {
            "name": "Tina",
            "popularity": 1.8375
          },
          {
            "name": "Agnes",
            "popularity": 1.8333333333333333
          },
          {
            "name": "Katherine",
            "popularity": 1.7352941176470589
          },
          {
            "name": "Colleen",
            "popularity": 1.6382978723404256
          },
          {
            "name": "Kristin",
            "popularity": 1.5671641791044777
          },
          {
            "name": "Leslie",
            "popularity": 1.496969696969697
          },
          {
            "name": "Teresa",
            "popularity": 1.4691358024691359
          },
          {
            "name": "Heather",
            "popularity": 1.423529411764706
          },
          {
            "name": "Heidi",
            "popularity": 1.3636363636363635
          },
          {
            "name": "Valerie",
            "popularity": 1.349726775956284
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Shawn",
            "popularity": 3.152542372881356
          },
          {
            "name": "Jason",
            "popularity": 2.75
          },
          {
            "name": "Troy",
            "popularity": 1.6666666666666667
          },
          {
            "name": "Tracy",
            "popularity": 1.6229508196721312
          },
          {
            "name": "Sean",
            "popularity": 1.56198347107438
          },
          {
            "name": "Peter",
            "popularity": 1.525164113785558
          },
          {
            "name": "Patrick",
            "popularity": 1.4470284237726099
          },
          {
            "name": "Karl",
            "popularity": 1.4047619047619047
          },
          {
            "name": "Matthew",
            "popularity": 1.3063063063063063
          },
          {
            "name": "Dwayne",
            "popularity": 1.28125
          },
          {
            "name": "Darren",
            "popularity": 1.2268041237113403
          },
          {
            "name": "Eric",
            "popularity": 1.2032258064516128
          },
          {
            "name": "Mike",
            "popularity": 1.1521739130434783
          },
          {
            "name": "Andrew",
            "popularity": 1.1368715083798884
          },
          {
            "name": "Micheal",
            "popularity": 1.128
          }
        ]
      }
    ]
  },
  {
    "state": "AL",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Annie",
            "popularity": 4.750778816199377
          },
          {
            "name": "Willie",
            "popularity": 3.771573604060914
          },
          {
            "name": "Mattie",
            "popularity": 3.688888888888889
          },
          {
            "name": "Johnnie",
            "popularity": 3.3378378378378377
          },
          {
            "name": "Rosie",
            "popularity": 3.0344827586206895
          },
          {
            "name": "Shelia",
            "popularity": 2.9873417721518987
          },
          {
            "name": "Katie",
            "popularity": 2.9642857142857144
          },
          {
            "name": "Fannie",
            "popularity": 2.8395061728395063
          },
          {
            "name": "Lillie",
            "popularity": 2.704697986577181
          },
          {
            "name": "Essie",
            "popularity": 2.627450980392157
          },
          {
            "name": "Lula",
            "popularity": 2.5357142857142856
          },
          {
            "name": "Minnie",
            "popularity": 2.4122137404580153
          },
          {
            "name": "Hattie",
            "popularity": 2.3176470588235296
          },
          {
            "name": "Mamie",
            "popularity": 2.3013698630136985
          },
          {
            "name": "Susie",
            "popularity": 2.2987012987012987
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Willie",
            "popularity": 4.27348643006263
          },
          {
            "name": "Charlie",
            "popularity": 3.1188811188811187
          },
          {
            "name": "Earnest",
            "popularity": 2.676470588235294
          },
          {
            "name": "Jessie",
            "popularity": 2.6122448979591835
          },
          {
            "name": "Johnnie",
            "popularity": 2.5535714285714284
          },
          {
            "name": "Rickey",
            "popularity": 2.3295454545454546
          },
          {
            "name": "Eddie",
            "popularity": 2.284263959390863
          },
          {
            "name": "Jimmie",
            "popularity": 2.24031007751938
          },
          {
            "name": "Horace",
            "popularity": 2.129032258064516
          },
          {
            "name": "Otis",
            "popularity": 2.1
          },
          {
            "name": "Jimmy",
            "popularity": 2.0474452554744524
          },
          {
            "name": "Johnny",
            "popularity": 1.9124087591240877
          },
          {
            "name": "Billy",
            "popularity": 1.825436408977556
          },
          {
            "name": "Bennie",
            "popularity": 1.793103448275862
          },
          {
            "name": "Nathaniel",
            "popularity": 1.7361111111111112
          }
        ]
      }
    ]
  },
  {
    "state": "AR",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Rosie",
            "popularity": 3.2298850574712645
          },
          {
            "name": "Bobbie",
            "popularity": 2.79
          },
          {
            "name": "Erma",
            "popularity": 2.772727272727273
          },
          {
            "name": "Patsy",
            "popularity": 2.5576923076923075
          },
          {
            "name": "Billie",
            "popularity": 2.4862385321100917
          },
          {
            "name": "Ruby",
            "popularity": 2.279503105590062
          },
          {
            "name": "Velma",
            "popularity": 2.2450980392156863
          },
          {
            "name": "Opal",
            "popularity": 2.216494845360825
          },
          {
            "name": "Ollie",
            "popularity": 2.196078431372549
          },
          {
            "name": "Geneva",
            "popularity": 2.163265306122449
          },
          {
            "name": "Willie",
            "popularity": 2.116751269035533
          },
          {
            "name": "Essie",
            "popularity": 1.9411764705882353
          },
          {
            "name": "Jessie",
            "popularity": 1.8828125
          },
          {
            "name": "Shelia",
            "popularity": 1.8481012658227849
          },
          {
            "name": "Lola",
            "popularity": 1.838235294117647
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Rickey",
            "popularity": 3.6363636363636362
          },
          {
            "name": "Billy",
            "popularity": 3.309226932668329
          },
          {
            "name": "Bobby",
            "popularity": 3.241590214067278
          },
          {
            "name": "Jimmy",
            "popularity": 2.9051094890510947
          },
          {
            "name": "Jessie",
            "popularity": 2.489795918367347
          },
          {
            "name": "Earnest",
            "popularity": 2.426470588235294
          },
          {
            "name": "Freddie",
            "popularity": 2.3205128205128207
          },
          {
            "name": "Tommy",
            "popularity": 2.280701754385965
          },
          {
            "name": "Jimmie",
            "popularity": 2.201550387596899
          },
          {
            "name": "Otis",
            "popularity": 2.15
          },
          {
            "name": "Jackie",
            "popularity": 2.1382978723404253
          },
          {
            "name": "Bennie",
            "popularity": 1.896551724137931
          },
          {
            "name": "Luther",
            "popularity": 1.8059701492537314
          },
          {
            "name": "Cecil",
            "popularity": 1.7478260869565216
          },
          {
            "name": "Donnie",
            "popularity": 1.7462686567164178
          }
        ]
      }
    ]
  },
  {
    "state": "AZ",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Carmen",
            "popularity": 5.6421052631578945
          },
          {
            "name": "Cecilia",
            "popularity": 3.719298245614035
          },
          {
            "name": "Maria",
            "popularity": 3.6487341772151898
          },
          {
            "name": "Lupe",
            "popularity": 3.2222222222222223
          },
          {
            "name": "Lydia",
            "popularity": 3.1973684210526314
          },
          {
            "name": "Yolanda",
            "popularity": 3
          },
          {
            "name": "Ramona",
            "popularity": 2.5555555555555554
          },
          {
            "name": "Dora",
            "popularity": 1.956043956043956
          },
          {
            "name": "Guadalupe",
            "popularity": 1.9111111111111112
          },
          {
            "name": "Susie",
            "popularity": 1.6103896103896105
          },
          {
            "name": "Alicia",
            "popularity": 1.606060606060606
          },
          {
            "name": "Veronica",
            "popularity": 1.5044247787610618
          },
          {
            "name": "Christina",
            "popularity": 1.4916666666666667
          },
          {
            "name": "Rosie",
            "popularity": 1.471264367816092
          },
          {
            "name": "Monica",
            "popularity": 1.3944954128440368
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Manuel",
            "popularity": 8.981818181818182
          },
          {
            "name": "Ruben",
            "popularity": 5.639344262295082
          },
          {
            "name": "Francisco",
            "popularity": 5
          },
          {
            "name": "Carlos",
            "popularity": 4.417721518987341
          },
          {
            "name": "Jesus",
            "popularity": 4.333333333333333
          },
          {
            "name": "Jose",
            "popularity": 3.5990338164251208
          },
          {
            "name": "Gilbert",
            "popularity": 3.4796747967479673
          },
          {
            "name": "Antonio",
            "popularity": 3.4642857142857144
          },
          {
            "name": "Raul",
            "popularity": 3.1449275362318843
          },
          {
            "name": "Alex",
            "popularity": 3.078125
          },
          {
            "name": "Hector",
            "popularity": 2.9622641509433962
          },
          {
            "name": "Miguel",
            "popularity": 2.7222222222222223
          },
          {
            "name": "Juan",
            "popularity": 2.4488188976377954
          },
          {
            "name": "Luis",
            "popularity": 2.3529411764705883
          },
          {
            "name": "Woodrow",
            "popularity": 2.0576923076923075
          }
        ]
      }
    ]
  },
  {
    "state": "CA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Christina",
            "popularity": 1.3583333333333334
          },
          {
            "name": "Carmen",
            "popularity": 1.3473684210526315
          },
          {
            "name": "Yolanda",
            "popularity": 1.2571428571428571
          },
          {
            "name": "Teri",
            "popularity": 1.0597014925373134
          },
          {
            "name": "Maria",
            "popularity": 1.0063291139240507
          },
          {
            "name": "Pat",
            "popularity": 0.9074074074074074
          },
          {
            "name": "Cecilia",
            "popularity": 0.8771929824561403
          },
          {
            "name": "Leslie",
            "popularity": 0.8484848484848485
          },
          {
            "name": "Julie",
            "popularity": 0.8373333333333334
          },
          {
            "name": "Victoria",
            "popularity": 0.8285714285714286
          },
          {
            "name": "Monica",
            "popularity": 0.7798165137614679
          },
          {
            "name": "Ramona",
            "popularity": 0.7638888888888888
          },
          {
            "name": "Alicia",
            "popularity": 0.7272727272727273
          },
          {
            "name": "Lydia",
            "popularity": 0.7236842105263158
          },
          {
            "name": "Shannon",
            "popularity": 0.7176470588235294
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Manuel",
            "popularity": 2.327272727272727
          },
          {
            "name": "Ruben",
            "popularity": 2
          },
          {
            "name": "Carlos",
            "popularity": 1.4556962025316456
          },
          {
            "name": "Mario",
            "popularity": 1.2307692307692308
          },
          {
            "name": "Mike",
            "popularity": 1.1956521739130435
          },
          {
            "name": "Jason",
            "popularity": 1.0694444444444444
          },
          {
            "name": "Bob",
            "popularity": 1.0357142857142858
          },
          {
            "name": "Lance",
            "popularity": 0.9821428571428571
          },
          {
            "name": "Gilbert",
            "popularity": 0.967479674796748
          },
          {
            "name": "Jim",
            "popularity": 0.9651162790697675
          },
          {
            "name": "Dave",
            "popularity": 0.8823529411764706
          },
          {
            "name": "Jose",
            "popularity": 0.8599033816425121
          },
          {
            "name": "Ricardo",
            "popularity": 0.8545454545454545
          },
          {
            "name": "Eric",
            "popularity": 0.8290322580645161
          },
          {
            "name": "Chris",
            "popularity": 0.824
          }
        ]
      }
    ]
  },
  {
    "state": "CO",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Kristi",
            "popularity": 1.9615384615384615
          },
          {
            "name": "Shelly",
            "popularity": 1.3679245283018868
          },
          {
            "name": "Olive",
            "popularity": 1.2692307692307692
          },
          {
            "name": "Bernadette",
            "popularity": 1.2105263157894737
          },
          {
            "name": "Ramona",
            "popularity": 1.1944444444444444
          },
          {
            "name": "Becky",
            "popularity": 1.1009174311926606
          },
          {
            "name": "Nicole",
            "popularity": 1.0909090909090908
          },
          {
            "name": "Heather",
            "popularity": 1.0823529411764705
          },
          {
            "name": "Della",
            "popularity": 1.0526315789473684
          },
          {
            "name": "Heidi",
            "popularity": 1.0303030303030303
          },
          {
            "name": "Erma",
            "popularity": 1.0151515151515151
          },
          {
            "name": "Dianna",
            "popularity": 1.0147058823529411
          },
          {
            "name": "Karla",
            "popularity": 0.9682539682539683
          },
          {
            "name": "Kelli",
            "popularity": 0.9636363636363636
          },
          {
            "name": "Tamara",
            "popularity": 0.9099099099099099
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Kent",
            "popularity": 1.9857142857142858
          },
          {
            "name": "Manuel",
            "popularity": 1.6363636363636365
          },
          {
            "name": "Kirk",
            "popularity": 1.6056338028169015
          },
          {
            "name": "Woodrow",
            "popularity": 1.5576923076923077
          },
          {
            "name": "Gilbert",
            "popularity": 1.3739837398373984
          },
          {
            "name": "Kelly",
            "popularity": 1.3472222222222223
          },
          {
            "name": "Brett",
            "popularity": 1.2876712328767124
          },
          {
            "name": "Bob",
            "popularity": 1.2053571428571428
          },
          {
            "name": "Shawn",
            "popularity": 1.11864406779661
          },
          {
            "name": "Delbert",
            "popularity": 1.1090909090909091
          },
          {
            "name": "Rick",
            "popularity": 1.104
          },
          {
            "name": "Mike",
            "popularity": 1.0695652173913044
          },
          {
            "name": "Jason",
            "popularity": 1.0277777777777777
          },
          {
            "name": "Joe",
            "popularity": 0.9848484848484849
          },
          {
            "name": "Dave",
            "popularity": 0.9705882352941176
          }
        ]
      }
    ]
  },
  {
    "state": "CT",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Sophie",
            "popularity": 2.6557377049180326
          },
          {
            "name": "Doreen",
            "popularity": 2.646153846153846
          },
          {
            "name": "Claire",
            "popularity": 1.7721518987341771
          },
          {
            "name": "Lynn",
            "popularity": 1.663716814159292
          },
          {
            "name": "Gail",
            "popularity": 1.5643939393939394
          },
          {
            "name": "Antoinette",
            "popularity": 1.5256410256410255
          },
          {
            "name": "Kristen",
            "popularity": 1.509433962264151
          },
          {
            "name": "Maureen",
            "popularity": 1.4825581395348837
          },
          {
            "name": "Maryann",
            "popularity": 1.4605263157894737
          },
          {
            "name": "Laurie",
            "popularity": 1.4080717488789238
          },
          {
            "name": "Marion",
            "popularity": 1.3429951690821256
          },
          {
            "name": "Jennie",
            "popularity": 1.2577319587628866
          },
          {
            "name": "Heather",
            "popularity": 1.188235294117647
          },
          {
            "name": "Anne",
            "popularity": 1.1428571428571428
          },
          {
            "name": "Lynne",
            "popularity": 1.10989010989011
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Peter",
            "popularity": 2.448577680525164
          },
          {
            "name": "Nicholas",
            "popularity": 1.983739837398374
          },
          {
            "name": "Salvatore",
            "popularity": 1.9325842696629214
          },
          {
            "name": "Jonathan",
            "popularity": 1.7372881355932204
          },
          {
            "name": "Angelo",
            "popularity": 1.625
          },
          {
            "name": "Francis",
            "popularity": 1.4749163879598661
          },
          {
            "name": "Alexander",
            "popularity": 1.3529411764705883
          },
          {
            "name": "Vincent",
            "popularity": 1.269406392694064
          },
          {
            "name": "Marc",
            "popularity": 1.1714285714285715
          },
          {
            "name": "Frederick",
            "popularity": 1.1526104417670682
          },
          {
            "name": "Sean",
            "popularity": 1.1322314049586777
          },
          {
            "name": "Anthony",
            "popularity": 1.0221238938053097
          },
          {
            "name": "Louis",
            "popularity": 0.9655172413793104
          },
          {
            "name": "Joseph",
            "popularity": 0.9080841638981174
          },
          {
            "name": "Theodore",
            "popularity": 0.841025641025641
          }
        ]
      }
    ]
  },
  {
    "state": "DC",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Cassandra",
            "popularity": 2.0185185185185186
          },
          {
            "name": "Crystal",
            "popularity": 2.0172413793103448
          },
          {
            "name": "Yvette",
            "popularity": 1.8666666666666667
          },
          {
            "name": "Tonya",
            "popularity": 1.8333333333333333
          },
          {
            "name": "Tanya",
            "popularity": 1.71875
          },
          {
            "name": "Gwendolyn",
            "popularity": 1.5593220338983051
          },
          {
            "name": "Leslie",
            "popularity": 1.406060606060606
          },
          {
            "name": "Jacqueline",
            "popularity": 1.3682539682539683
          },
          {
            "name": "Delores",
            "popularity": 1.3310810810810811
          },
          {
            "name": "Laverne",
            "popularity": 1.3272727272727274
          },
          {
            "name": "Renee",
            "popularity": 1.31875
          },
          {
            "name": "Vanessa",
            "popularity": 1.316326530612245
          },
          {
            "name": "Nicole",
            "popularity": 1.290909090909091
          },
          {
            "name": "Monica",
            "popularity": 1.2568807339449541
          },
          {
            "name": "Yvonne",
            "popularity": 1.2531645569620253
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Tyrone",
            "popularity": 5.2631578947368425
          },
          {
            "name": "Reginald",
            "popularity": 3.7848101265822787
          },
          {
            "name": "Derrick",
            "popularity": 2.626865671641791
          },
          {
            "name": "Maurice",
            "popularity": 1.9081632653061225
          },
          {
            "name": "Ricardo",
            "popularity": 1.7636363636363637
          },
          {
            "name": "Derek",
            "popularity": 1.7358490566037736
          },
          {
            "name": "Darryl",
            "popularity": 1.693069306930693
          },
          {
            "name": "Dwayne",
            "popularity": 1.6875
          },
          {
            "name": "Nathaniel",
            "popularity": 1.4166666666666667
          },
          {
            "name": "Jonathan",
            "popularity": 1.3305084745762712
          },
          {
            "name": "Sean",
            "popularity": 1.2314049586776858
          },
          {
            "name": "Eric",
            "popularity": 1.2193548387096773
          },
          {
            "name": "Clifton",
            "popularity": 1.1666666666666667
          },
          {
            "name": "Bernard",
            "popularity": 1.0934579439252337
          },
          {
            "name": "Christopher",
            "popularity": 1
          }
        ]
      }
    ]
  },
  {
    "state": "DE",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Crystal",
            "popularity": 3.396551724137931
          },
          {
            "name": "Sophie",
            "popularity": 2.8688524590163933
          },
          {
            "name": "Mabel",
            "popularity": 2.5784313725490198
          },
          {
            "name": "Stella",
            "popularity": 2.3389830508474576
          },
          {
            "name": "Hilda",
            "popularity": 2.325301204819277
          },
          {
            "name": "Heather",
            "popularity": 2.1294117647058823
          },
          {
            "name": "Elsie",
            "popularity": 2.096969696969697
          },
          {
            "name": "Pearl",
            "popularity": 1.8387096774193548
          },
          {
            "name": "Nicole",
            "popularity": 1.8363636363636364
          },
          {
            "name": "Agnes",
            "popularity": 1.68
          },
          {
            "name": "Holly",
            "popularity": 1.588785046728972
          },
          {
            "name": "Kristin",
            "popularity": 1.5820895522388059
          },
          {
            "name": "Olive",
            "popularity": 1.5192307692307692
          },
          {
            "name": "Dawn",
            "popularity": 1.5155038759689923
          },
          {
            "name": "Blanche",
            "popularity": 1.4487179487179487
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Woodrow",
            "popularity": 3.980769230769231
          },
          {
            "name": "Francis",
            "popularity": 2.3812709030100336
          },
          {
            "name": "Sean",
            "popularity": 1.421487603305785
          },
          {
            "name": "Matthew",
            "popularity": 1.2567567567567568
          },
          {
            "name": "Tyrone",
            "popularity": 1.2456140350877194
          },
          {
            "name": "Harry",
            "popularity": 1.2115384615384615
          },
          {
            "name": "Christopher",
            "popularity": 1.1651982378854626
          },
          {
            "name": "Roland",
            "popularity": 1.1578947368421053
          },
          {
            "name": "Franklin",
            "popularity": 1.139344262295082
          },
          {
            "name": "Dwayne",
            "popularity": 1.0625
          },
          {
            "name": "Horace",
            "popularity": 1.0483870967741935
          },
          {
            "name": "Willard",
            "popularity": 1.0470588235294118
          },
          {
            "name": "Wayne",
            "popularity": 1.0395778364116095
          },
          {
            "name": "Bryan",
            "popularity": 1.0256410256410255
          },
          {
            "name": "Jonathan",
            "popularity": 0.9067796610169492
          }
        ]
      }
    ]
  },
  {
    "state": "FL",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Cassandra",
            "popularity": 1.7037037037037037
          },
          {
            "name": "Gwendolyn",
            "popularity": 1.5338983050847457
          },
          {
            "name": "Jacquelyn",
            "popularity": 1.323076923076923
          },
          {
            "name": "Rosa",
            "popularity": 1.0431654676258992
          },
          {
            "name": "Essie",
            "popularity": 0.9803921568627451
          },
          {
            "name": "Belinda",
            "popularity": 0.967032967032967
          },
          {
            "name": "Ernestine",
            "popularity": 0.9090909090909091
          },
          {
            "name": "Annie",
            "popularity": 0.8691588785046729
          },
          {
            "name": "Tina",
            "popularity": 0.8291666666666667
          },
          {
            "name": "Daisy",
            "popularity": 0.8285714285714286
          },
          {
            "name": "Johnnie",
            "popularity": 0.8243243243243243
          },
          {
            "name": "Iris",
            "popularity": 0.8214285714285714
          },
          {
            "name": "Angela",
            "popularity": 0.8207547169811321
          },
          {
            "name": "Willie",
            "popularity": 0.7715736040609137
          },
          {
            "name": "Inez",
            "popularity": 0.7428571428571429
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Nathaniel",
            "popularity": 2.236111111111111
          },
          {
            "name": "Freddie",
            "popularity": 1.7435897435897436
          },
          {
            "name": "Willie",
            "popularity": 1.7139874739039667
          },
          {
            "name": "Johnnie",
            "popularity": 1.4375
          },
          {
            "name": "Reginald",
            "popularity": 1.3670886075949367
          },
          {
            "name": "Horace",
            "popularity": 1.1774193548387097
          },
          {
            "name": "Eddie",
            "popularity": 1.0964467005076142
          },
          {
            "name": "Charlie",
            "popularity": 0.9020979020979021
          },
          {
            "name": "Derrick",
            "popularity": 0.8955223880597015
          },
          {
            "name": "Johnny",
            "popularity": 0.8394160583941606
          },
          {
            "name": "Jimmie",
            "popularity": 0.8372093023255814
          },
          {
            "name": "Dwayne",
            "popularity": 0.765625
          },
          {
            "name": "Tyrone",
            "popularity": 0.7543859649122807
          },
          {
            "name": "Earnest",
            "popularity": 0.75
          },
          {
            "name": "Otis",
            "popularity": 0.7166666666666667
          }
        ]
      }
    ]
  },
  {
    "state": "GA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Annie",
            "popularity": 3.9968847352024923
          },
          {
            "name": "Mattie",
            "popularity": 3.762962962962963
          },
          {
            "name": "Willie",
            "popularity": 3.1776649746192893
          },
          {
            "name": "Essie",
            "popularity": 3.0980392156862746
          },
          {
            "name": "Mamie",
            "popularity": 3.0273972602739727
          },
          {
            "name": "Johnnie",
            "popularity": 2.72972972972973
          },
          {
            "name": "Susie",
            "popularity": 2.4935064935064934
          },
          {
            "name": "Fannie",
            "popularity": 2.4444444444444446
          },
          {
            "name": "Lillie",
            "popularity": 2.4093959731543624
          },
          {
            "name": "Hattie",
            "popularity": 2.2823529411764705
          },
          {
            "name": "Katie",
            "popularity": 2.25
          },
          {
            "name": "Sara",
            "popularity": 2.183006535947712
          },
          {
            "name": "Rosa",
            "popularity": 2.172661870503597
          },
          {
            "name": "Daisy",
            "popularity": 2.0714285714285716
          },
          {
            "name": "Lucile",
            "popularity": 2.0677966101694913
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Charlie",
            "popularity": 4.636363636363637
          },
          {
            "name": "Willie",
            "popularity": 4.569937369519833
          },
          {
            "name": "Horace",
            "popularity": 3.0806451612903225
          },
          {
            "name": "Otis",
            "popularity": 2.7333333333333334
          },
          {
            "name": "Bennie",
            "popularity": 2.4827586206896552
          },
          {
            "name": "Johnnie",
            "popularity": 2.4375
          },
          {
            "name": "Eddie",
            "popularity": 2.3908629441624365
          },
          {
            "name": "Freddie",
            "popularity": 2.1153846153846154
          },
          {
            "name": "Nathaniel",
            "popularity": 2.0833333333333335
          },
          {
            "name": "Earnest",
            "popularity": 2.073529411764706
          },
          {
            "name": "Johnny",
            "popularity": 2.04014598540146
          },
          {
            "name": "Marion",
            "popularity": 1.8125
          },
          {
            "name": "Hugh",
            "popularity": 1.7721518987341771
          },
          {
            "name": "Hubert",
            "popularity": 1.7692307692307692
          },
          {
            "name": "Luther",
            "popularity": 1.7462686567164178
          }
        ]
      }
    ]
  },
  {
    "state": "HI",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Kiyoko",
            "popularity": 6.807017543859649
          },
          {
            "name": "Yoshiko",
            "popularity": 6.404494382022472
          },
          {
            "name": "Masako",
            "popularity": 5.983606557377049
          },
          {
            "name": "Fumiko",
            "popularity": 5.910714285714286
          },
          {
            "name": "Mitsue",
            "popularity": 5.867924528301887
          },
          {
            "name": "Shizue",
            "popularity": 4.775280898876405
          },
          {
            "name": "Roxanne",
            "popularity": 4.723076923076923
          },
          {
            "name": "Bernadette",
            "popularity": 4.578947368421052
          },
          {
            "name": "Yoshie",
            "popularity": 4.026666666666666
          },
          {
            "name": "Kikue",
            "popularity": 3.9655172413793105
          },
          {
            "name": "Shizuko",
            "popularity": 3.962962962962963
          },
          {
            "name": "Iris",
            "popularity": 3.892857142857143
          },
          {
            "name": "Mitsuko",
            "popularity": 3.8875
          },
          {
            "name": "Violet",
            "popularity": 3.6320754716981134
          },
          {
            "name": "Doreen",
            "popularity": 3.4153846153846152
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Toshio",
            "popularity": 7.901960784313726
          },
          {
            "name": "Yoshio",
            "popularity": 7.897435897435898
          },
          {
            "name": "Kiyoshi",
            "popularity": 6.985074626865671
          },
          {
            "name": "Kazuo",
            "popularity": 6.444444444444445
          },
          {
            "name": "Lance",
            "popularity": 6.089285714285714
          },
          {
            "name": "Minoru",
            "popularity": 5.980769230769231
          },
          {
            "name": "Derek",
            "popularity": 5.962264150943396
          },
          {
            "name": "Takeo",
            "popularity": 4.955882352941177
          },
          {
            "name": "Jason",
            "popularity": 4.805555555555555
          },
          {
            "name": "Clayton",
            "popularity": 4.389830508474576
          },
          {
            "name": "Shigeo",
            "popularity": 4.311475409836065
          },
          {
            "name": "Nathan",
            "popularity": 3.9516129032258065
          },
          {
            "name": "Guy",
            "popularity": 3.588235294117647
          },
          {
            "name": "Wendell",
            "popularity": 3.207547169811321
          },
          {
            "name": "Sean",
            "popularity": 3.0165289256198347
          }
        ]
      }
    ]
  },
  {
    "state": "IA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Becky",
            "popularity": 1.926605504587156
          },
          {
            "name": "Karla",
            "popularity": 1.9206349206349207
          },
          {
            "name": "Maxine",
            "popularity": 1.8257575757575757
          },
          {
            "name": "Shelly",
            "popularity": 1.820754716981132
          },
          {
            "name": "Kristi",
            "popularity": 1.5769230769230769
          },
          {
            "name": "Julie",
            "popularity": 1.5226666666666666
          },
          {
            "name": "Jodi",
            "popularity": 1.4431818181818181
          },
          {
            "name": "Sheryl",
            "popularity": 1.403225806451613
          },
          {
            "name": "Marcella",
            "popularity": 1.3387096774193548
          },
          {
            "name": "Connie",
            "popularity": 1.3268608414239482
          },
          {
            "name": "Erma",
            "popularity": 1.2878787878787878
          },
          {
            "name": "Tami",
            "popularity": 1.2857142857142858
          },
          {
            "name": "Jody",
            "popularity": 1.2686567164179106
          },
          {
            "name": "Kristine",
            "popularity": 1.2272727272727273
          },
          {
            "name": "Roxanne",
            "popularity": 1.1076923076923078
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Lyle",
            "popularity": 3.761904761904762
          },
          {
            "name": "Duane",
            "popularity": 2.5080645161290325
          },
          {
            "name": "Kent",
            "popularity": 2.157142857142857
          },
          {
            "name": "Dean",
            "popularity": 2.0961538461538463
          },
          {
            "name": "Woodrow",
            "popularity": 1.7884615384615385
          },
          {
            "name": "Darin",
            "popularity": 1.7735849056603774
          },
          {
            "name": "Max",
            "popularity": 1.6849315068493151
          },
          {
            "name": "Bradley",
            "popularity": 1.6097560975609757
          },
          {
            "name": "Rick",
            "popularity": 1.584
          },
          {
            "name": "Delbert",
            "popularity": 1.5636363636363637
          },
          {
            "name": "Virgil",
            "popularity": 1.4743589743589745
          },
          {
            "name": "Dale",
            "popularity": 1.4707792207792207
          },
          {
            "name": "Lynn",
            "popularity": 1.45
          },
          {
            "name": "Jon",
            "popularity": 1.4482758620689655
          },
          {
            "name": "Rex",
            "popularity": 1.4385964912280702
          }
        ]
      }
    ]
  },
  {
    "state": "ID",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Olive",
            "popularity": 3.8076923076923075
          },
          {
            "name": "Karla",
            "popularity": 3.2063492063492065
          },
          {
            "name": "Heather",
            "popularity": 2.9176470588235293
          },
          {
            "name": "Shannon",
            "popularity": 2.8117647058823527
          },
          {
            "name": "Shelley",
            "popularity": 2.730337078651685
          },
          {
            "name": "Kristi",
            "popularity": 2.5576923076923075
          },
          {
            "name": "Maxine",
            "popularity": 2.5303030303030303
          },
          {
            "name": "Becky",
            "popularity": 2.467889908256881
          },
          {
            "name": "Blanche",
            "popularity": 2.358974358974359
          },
          {
            "name": "Tamara",
            "popularity": 2.3423423423423424
          },
          {
            "name": "Robyn",
            "popularity": 2.169811320754717
          },
          {
            "name": "Tami",
            "popularity": 2.1587301587301586
          },
          {
            "name": "Jody",
            "popularity": 2.1194029850746268
          },
          {
            "name": "Opal",
            "popularity": 2.0927835051546393
          },
          {
            "name": "Shelly",
            "popularity": 2.018867924528302
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Kelly",
            "popularity": 5.944444444444445
          },
          {
            "name": "Brent",
            "popularity": 5.585365853658536
          },
          {
            "name": "Darin",
            "popularity": 5.452830188679245
          },
          {
            "name": "Lynn",
            "popularity": 5.183333333333334
          },
          {
            "name": "Woodrow",
            "popularity": 4.230769230769231
          },
          {
            "name": "Kim",
            "popularity": 3.8793103448275863
          },
          {
            "name": "Kent",
            "popularity": 3.842857142857143
          },
          {
            "name": "Lyle",
            "popularity": 3.4126984126984126
          },
          {
            "name": "Rex",
            "popularity": 3.3508771929824563
          },
          {
            "name": "Max",
            "popularity": 2.9726027397260273
          },
          {
            "name": "Tracy",
            "popularity": 2.819672131147541
          },
          {
            "name": "Brett",
            "popularity": 2.493150684931507
          },
          {
            "name": "Brad",
            "popularity": 2.4743589743589745
          },
          {
            "name": "Delbert",
            "popularity": 2.4
          },
          {
            "name": "Rick",
            "popularity": 2.264
          }
        ]
      }
    ]
  },
  {
    "state": "IL",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Laverne",
            "popularity": 1.2727272727272727
          },
          {
            "name": "Dolores",
            "popularity": 0.6666666666666666
          },
          {
            "name": "Genevieve",
            "popularity": 0.6222222222222222
          },
          {
            "name": "Rosemary",
            "popularity": 0.611764705882353
          },
          {
            "name": "Lorraine",
            "popularity": 0.6056910569105691
          },
          {
            "name": "Marcella",
            "popularity": 0.5806451612903226
          },
          {
            "name": "Pat",
            "popularity": 0.5555555555555556
          },
          {
            "name": "Marianne",
            "popularity": 0.5
          },
          {
            "name": "Marilyn",
            "popularity": 0.4610244988864143
          },
          {
            "name": "Judith",
            "popularity": 0.41637010676156583
          },
          {
            "name": "Loretta",
            "popularity": 0.38341968911917096
          },
          {
            "name": "Arlene",
            "popularity": 0.37037037037037035
          },
          {
            "name": "Eileen",
            "popularity": 0.35436893203883496
          },
          {
            "name": "Bernice",
            "popularity": 0.34782608695652173
          },
          {
            "name": "Kristine",
            "popularity": 0.3409090909090909
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Jerome",
            "popularity": 0.6040268456375839
          },
          {
            "name": "Derrick",
            "popularity": 0.5373134328358209
          },
          {
            "name": "Tyrone",
            "popularity": 0.47368421052631576
          },
          {
            "name": "Maurice",
            "popularity": 0.42857142857142855
          },
          {
            "name": "Bradley",
            "popularity": 0.36585365853658536
          },
          {
            "name": "Tom",
            "popularity": 0.3355263157894737
          },
          {
            "name": "Lyle",
            "popularity": 0.3333333333333333
          },
          {
            "name": "Brad",
            "popularity": 0.2948717948717949
          },
          {
            "name": "Chester",
            "popularity": 0.2734375
          },
          {
            "name": "Patrick",
            "popularity": 0.26356589147286824
          },
          {
            "name": "Kurt",
            "popularity": 0.2558139534883721
          },
          {
            "name": "Lawrence",
            "popularity": 0.2521186440677966
          },
          {
            "name": "Bob",
            "popularity": 0.25
          },
          {
            "name": "Martin",
            "popularity": 0.24796747967479674
          },
          {
            "name": "Darryl",
            "popularity": 0.24752475247524752
          }
        ]
      }
    ]
  },
  {
    "state": "IN",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Tamara",
            "popularity": 1.3513513513513513
          },
          {
            "name": "Patty",
            "popularity": 1.1927710843373494
          },
          {
            "name": "Tina",
            "popularity": 1.15
          },
          {
            "name": "Wilma",
            "popularity": 1.0172413793103448
          },
          {
            "name": "Penny",
            "popularity": 0.968503937007874
          },
          {
            "name": "Beth",
            "popularity": 0.959731543624161
          },
          {
            "name": "Marsha",
            "popularity": 0.952054794520548
          },
          {
            "name": "Olive",
            "popularity": 0.9423076923076923
          },
          {
            "name": "Sue",
            "popularity": 0.9367816091954023
          },
          {
            "name": "Lana",
            "popularity": 0.9215686274509803
          },
          {
            "name": "Dianna",
            "popularity": 0.9117647058823529
          },
          {
            "name": "Tonya",
            "popularity": 0.8222222222222222
          },
          {
            "name": "Marcia",
            "popularity": 0.8141025641025641
          },
          {
            "name": "Rebecca",
            "popularity": 0.7552083333333334
          },
          {
            "name": "Cathy",
            "popularity": 0.7517985611510791
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Max",
            "popularity": 2.3698630136986303
          },
          {
            "name": "Rex",
            "popularity": 1.9298245614035088
          },
          {
            "name": "Kent",
            "popularity": 1.3714285714285714
          },
          {
            "name": "Rick",
            "popularity": 1.28
          },
          {
            "name": "Brent",
            "popularity": 1.1341463414634145
          },
          {
            "name": "Bradley",
            "popularity": 1.032520325203252
          },
          {
            "name": "Jeffery",
            "popularity": 0.9669421487603306
          },
          {
            "name": "Jeff",
            "popularity": 0.9470198675496688
          },
          {
            "name": "Tim",
            "popularity": 0.9459459459459459
          },
          {
            "name": "Wilbur",
            "popularity": 0.9047619047619048
          },
          {
            "name": "Darrin",
            "popularity": 0.8846153846153846
          },
          {
            "name": "Kerry",
            "popularity": 0.8793103448275862
          },
          {
            "name": "Darin",
            "popularity": 0.8679245283018868
          },
          {
            "name": "Garry",
            "popularity": 0.8333333333333334
          },
          {
            "name": "Terry",
            "popularity": 0.7539149888143176
          }
        ]
      }
    ]
  },
  {
    "state": "KS",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Karla",
            "popularity": 2.111111111111111
          },
          {
            "name": "Kristi",
            "popularity": 1.9230769230769231
          },
          {
            "name": "Maxine",
            "popularity": 1.8106060606060606
          },
          {
            "name": "Shelly",
            "popularity": 1.7924528301886793
          },
          {
            "name": "Wilma",
            "popularity": 1.7298850574712643
          },
          {
            "name": "Opal",
            "popularity": 1.556701030927835
          },
          {
            "name": "Deanna",
            "popularity": 1.4485981308411215
          },
          {
            "name": "Connie",
            "popularity": 1.4142394822006472
          },
          {
            "name": "Velma",
            "popularity": 1.392156862745098
          },
          {
            "name": "Lana",
            "popularity": 1.3725490196078431
          },
          {
            "name": "Lola",
            "popularity": 1.2941176470588236
          },
          {
            "name": "Dana",
            "popularity": 1.2678571428571428
          },
          {
            "name": "Beulah",
            "popularity": 1.2325581395348837
          },
          {
            "name": "Dianna",
            "popularity": 1.2205882352941178
          },
          {
            "name": "Sheryl",
            "popularity": 1.2016129032258065
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Darin",
            "popularity": 3.5283018867924527
          },
          {
            "name": "Max",
            "popularity": 2.452054794520548
          },
          {
            "name": "Rex",
            "popularity": 2.280701754385965
          },
          {
            "name": "Delbert",
            "popularity": 2.2
          },
          {
            "name": "Kelly",
            "popularity": 2.1666666666666665
          },
          {
            "name": "Virgil",
            "popularity": 2.0128205128205128
          },
          {
            "name": "Lyle",
            "popularity": 1.9841269841269842
          },
          {
            "name": "Kent",
            "popularity": 1.9142857142857144
          },
          {
            "name": "Bradley",
            "popularity": 1.6341463414634145
          },
          {
            "name": "Brad",
            "popularity": 1.5256410256410255
          },
          {
            "name": "Bob",
            "popularity": 1.375
          },
          {
            "name": "Brent",
            "popularity": 1.329268292682927
          },
          {
            "name": "Duane",
            "popularity": 1.2338709677419355
          },
          {
            "name": "Everett",
            "popularity": 1.2307692307692308
          },
          {
            "name": "Marion",
            "popularity": 1.2125
          }
        ]
      }
    ]
  },
  {
    "state": "KY",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Geneva",
            "popularity": 2.826530612244898
          },
          {
            "name": "Della",
            "popularity": 2.0701754385964914
          },
          {
            "name": "Opal",
            "popularity": 1.958762886597938
          },
          {
            "name": "Shelia",
            "popularity": 1.7974683544303798
          },
          {
            "name": "Wilma",
            "popularity": 1.7528735632183907
          },
          {
            "name": "Beulah",
            "popularity": 1.6162790697674418
          },
          {
            "name": "Ruby",
            "popularity": 1.4720496894409938
          },
          {
            "name": "Wanda",
            "popularity": 1.4252199413489737
          },
          {
            "name": "Vickie",
            "popularity": 1.3571428571428572
          },
          {
            "name": "Ada",
            "popularity": 1.3478260869565217
          },
          {
            "name": "Alma",
            "popularity": 1.2733812949640289
          },
          {
            "name": "Nora",
            "popularity": 1.2
          },
          {
            "name": "Myrtle",
            "popularity": 1.1825396825396826
          },
          {
            "name": "Thelma",
            "popularity": 1.102661596958175
          },
          {
            "name": "Eula",
            "popularity": 1.096774193548387
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Donnie",
            "popularity": 3.343283582089552
          },
          {
            "name": "Jackie",
            "popularity": 2.25531914893617
          },
          {
            "name": "Wendell",
            "popularity": 1.7924528301886793
          },
          {
            "name": "Homer",
            "popularity": 1.7285714285714286
          },
          {
            "name": "Virgil",
            "popularity": 1.7179487179487178
          },
          {
            "name": "Cecil",
            "popularity": 1.6869565217391305
          },
          {
            "name": "Ronnie",
            "popularity": 1.6462264150943395
          },
          {
            "name": "Bobby",
            "popularity": 1.5963302752293578
          },
          {
            "name": "Billy",
            "popularity": 1.5960099750623442
          },
          {
            "name": "Hubert",
            "popularity": 1.5384615384615385
          },
          {
            "name": "Garry",
            "popularity": 1.5
          },
          {
            "name": "Everett",
            "popularity": 1.4615384615384615
          },
          {
            "name": "Willard",
            "popularity": 1.3647058823529412
          },
          {
            "name": "Danny",
            "popularity": 1.3642857142857143
          },
          {
            "name": "Chester",
            "popularity": 1.3203125
          }
        ]
      }
    ]
  },
  {
    "state": "LA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Shelia",
            "popularity": 2.5822784810126582
          },
          {
            "name": "Irma",
            "popularity": 1.8243243243243243
          },
          {
            "name": "Eula",
            "popularity": 1.7580645161290323
          },
          {
            "name": "Rosie",
            "popularity": 1.7126436781609196
          },
          {
            "name": "Vanessa",
            "popularity": 1.663265306122449
          },
          {
            "name": "Gwendolyn",
            "popularity": 1.61864406779661
          },
          {
            "name": "Mable",
            "popularity": 1.5396825396825398
          },
          {
            "name": "Lillie",
            "popularity": 1.436241610738255
          },
          {
            "name": "Hilda",
            "popularity": 1.3734939759036144
          },
          {
            "name": "Bobbie",
            "popularity": 1.31
          },
          {
            "name": "Glenda",
            "popularity": 1.3055555555555556
          },
          {
            "name": "Ella",
            "popularity": 1.3021582733812949
          },
          {
            "name": "Willie",
            "popularity": 1.284263959390863
          },
          {
            "name": "Cassandra",
            "popularity": 1.2407407407407407
          },
          {
            "name": "Paulette",
            "popularity": 1.2173913043478262
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Sidney",
            "popularity": 2.3846153846153846
          },
          {
            "name": "Clifton",
            "popularity": 2.25
          },
          {
            "name": "Freddie",
            "popularity": 2.230769230769231
          },
          {
            "name": "Alvin",
            "popularity": 2.0714285714285716
          },
          {
            "name": "Jessie",
            "popularity": 1.9387755102040816
          },
          {
            "name": "Dwayne",
            "popularity": 1.71875
          },
          {
            "name": "Willie",
            "popularity": 1.6346555323590815
          },
          {
            "name": "Tyrone",
            "popularity": 1.4912280701754386
          },
          {
            "name": "Oliver",
            "popularity": 1.4901960784313726
          },
          {
            "name": "Kerry",
            "popularity": 1.4655172413793103
          },
          {
            "name": "Herman",
            "popularity": 1.4295774647887325
          },
          {
            "name": "Earnest",
            "popularity": 1.411764705882353
          },
          {
            "name": "Calvin",
            "popularity": 1.401360544217687
          },
          {
            "name": "Byron",
            "popularity": 1.3584905660377358
          },
          {
            "name": "Rickey",
            "popularity": 1.3068181818181819
          }
        ]
      }
    ]
  },
  {
    "state": "MA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Claire",
            "popularity": 5.012658227848101
          },
          {
            "name": "Maureen",
            "popularity": 3.058139534883721
          },
          {
            "name": "Priscilla",
            "popularity": 2.2875
          },
          {
            "name": "Lynne",
            "popularity": 1.8571428571428572
          },
          {
            "name": "Jeannette",
            "popularity": 1.7794117647058822
          },
          {
            "name": "Anne",
            "popularity": 1.584717607973422
          },
          {
            "name": "Joanne",
            "popularity": 1.5236220472440944
          },
          {
            "name": "Doreen",
            "popularity": 1.476923076923077
          },
          {
            "name": "Eleanor",
            "popularity": 1.475177304964539
          },
          {
            "name": "Muriel",
            "popularity": 1.4179104477611941
          },
          {
            "name": "Sophie",
            "popularity": 1.3934426229508197
          },
          {
            "name": "Marion",
            "popularity": 1.289855072463768
          },
          {
            "name": "Jeanne",
            "popularity": 1.2827225130890052
          },
          {
            "name": "Eileen",
            "popularity": 1.2815533980582525
          },
          {
            "name": "Lorraine",
            "popularity": 1.2357723577235773
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Francis",
            "popularity": 2.842809364548495
          },
          {
            "name": "Peter",
            "popularity": 2.0568927789934355
          },
          {
            "name": "Gerard",
            "popularity": 2
          },
          {
            "name": "Dana",
            "popularity": 1.8703703703703705
          },
          {
            "name": "Roland",
            "popularity": 1.6421052631578947
          },
          {
            "name": "Leo",
            "popularity": 1.5030674846625767
          },
          {
            "name": "Frederick",
            "popularity": 1.2811244979919678
          },
          {
            "name": "Stephen",
            "popularity": 1.2660550458715596
          },
          {
            "name": "Philip",
            "popularity": 1.186206896551724
          },
          {
            "name": "Paul",
            "popularity": 1.179289026275116
          },
          {
            "name": "Jonathan",
            "popularity": 1.1440677966101696
          },
          {
            "name": "Alfred",
            "popularity": 1.0278884462151394
          },
          {
            "name": "Sean",
            "popularity": 0.9421487603305785
          },
          {
            "name": "Arthur",
            "popularity": 0.9026717557251909
          },
          {
            "name": "Joseph",
            "popularity": 0.8560354374307863
          }
        ]
      }
    ]
  },
  {
    "state": "MD",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Crystal",
            "popularity": 1.6551724137931034
          },
          {
            "name": "Hilda",
            "popularity": 1.3253012048192772
          },
          {
            "name": "Vanessa",
            "popularity": 1.3061224489795917
          },
          {
            "name": "Yvette",
            "popularity": 1.2166666666666666
          },
          {
            "name": "Robin",
            "popularity": 1.0163934426229508
          },
          {
            "name": "Darlene",
            "popularity": 0.888030888030888
          },
          {
            "name": "Rosalie",
            "popularity": 0.8873239436619719
          },
          {
            "name": "Bernadette",
            "popularity": 0.8245614035087719
          },
          {
            "name": "Dawn",
            "popularity": 0.813953488372093
          },
          {
            "name": "Terry",
            "popularity": 0.803030303030303
          },
          {
            "name": "Catherine",
            "popularity": 0.8010471204188482
          },
          {
            "name": "Tracey",
            "popularity": 0.7606837606837606
          },
          {
            "name": "Regina",
            "popularity": 0.75
          },
          {
            "name": "Naomi",
            "popularity": 0.75
          },
          {
            "name": "Michele",
            "popularity": 0.7490774907749077
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Tyrone",
            "popularity": 2.0701754385964914
          },
          {
            "name": "Dwayne",
            "popularity": 1.484375
          },
          {
            "name": "Roland",
            "popularity": 1.2105263157894737
          },
          {
            "name": "Reginald",
            "popularity": 1.1265822784810127
          },
          {
            "name": "Clifton",
            "popularity": 1.1166666666666667
          },
          {
            "name": "Bernard",
            "popularity": 1.0700934579439252
          },
          {
            "name": "Maurice",
            "popularity": 0.9693877551020408
          },
          {
            "name": "Franklin",
            "popularity": 0.8688524590163934
          },
          {
            "name": "Melvin",
            "popularity": 0.8611111111111112
          },
          {
            "name": "Milton",
            "popularity": 0.859504132231405
          },
          {
            "name": "Vernon",
            "popularity": 0.8397435897435898
          },
          {
            "name": "Jerome",
            "popularity": 0.8322147651006712
          },
          {
            "name": "Harry",
            "popularity": 0.8028846153846154
          },
          {
            "name": "Nelson",
            "popularity": 0.7321428571428571
          },
          {
            "name": "Darrin",
            "popularity": 0.7307692307692307
          }
        ]
      }
    ]
  },
  {
    "state": "ME",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Priscilla",
            "popularity": 4.3
          },
          {
            "name": "Jeannette",
            "popularity": 3.6323529411764706
          },
          {
            "name": "Muriel",
            "popularity": 3.3134328358208953
          },
          {
            "name": "Olive",
            "popularity": 2.6538461538461537
          },
          {
            "name": "Claire",
            "popularity": 2.5063291139240507
          },
          {
            "name": "Constance",
            "popularity": 2.2838709677419353
          },
          {
            "name": "Pauline",
            "popularity": 2.2650602409638556
          },
          {
            "name": "Madeline",
            "popularity": 2.066666666666667
          },
          {
            "name": "Laurie",
            "popularity": 1.9417040358744395
          },
          {
            "name": "Rachel",
            "popularity": 1.85
          },
          {
            "name": "Debora",
            "popularity": 1.6666666666666667
          },
          {
            "name": "Kristen",
            "popularity": 1.6226415094339623
          },
          {
            "name": "Marguerite",
            "popularity": 1.6105263157894736
          },
          {
            "name": "Heidi",
            "popularity": 1.5757575757575757
          },
          {
            "name": "Tina",
            "popularity": 1.5291666666666666
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Dana",
            "popularity": 7.277777777777778
          },
          {
            "name": "Roland",
            "popularity": 6.505263157894737
          },
          {
            "name": "Woodrow",
            "popularity": 4.3076923076923075
          },
          {
            "name": "Gerard",
            "popularity": 3.7222222222222223
          },
          {
            "name": "Maurice",
            "popularity": 3.622448979591837
          },
          {
            "name": "Clayton",
            "popularity": 2.864406779661017
          },
          {
            "name": "Reginald",
            "popularity": 2.632911392405063
          },
          {
            "name": "Everett",
            "popularity": 2.358974358974359
          },
          {
            "name": "Troy",
            "popularity": 2.140740740740741
          },
          {
            "name": "Philip",
            "popularity": 2.010344827586207
          },
          {
            "name": "Adam",
            "popularity": 1.962962962962963
          },
          {
            "name": "Normand",
            "popularity": 1.8518518518518519
          },
          {
            "name": "Marc",
            "popularity": 1.7142857142857142
          },
          {
            "name": "Leo",
            "popularity": 1.6932515337423313
          },
          {
            "name": "Shawn",
            "popularity": 1.61864406779661
          }
        ]
      }
    ]
  },
  {
    "state": "MI",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Sally",
            "popularity": 0.76
          },
          {
            "name": "Dawn",
            "popularity": 0.7403100775193798
          },
          {
            "name": "Colleen",
            "popularity": 0.6524822695035462
          },
          {
            "name": "Sue",
            "popularity": 0.6264367816091954
          },
          {
            "name": "Julie",
            "popularity": 0.616
          },
          {
            "name": "Marcia",
            "popularity": 0.6025641025641025
          },
          {
            "name": "Kay",
            "popularity": 0.5785123966942148
          },
          {
            "name": "Genevieve",
            "popularity": 0.5777777777777777
          },
          {
            "name": "Kelly",
            "popularity": 0.5564738292011019
          },
          {
            "name": "Suzanne",
            "popularity": 0.5281385281385281
          },
          {
            "name": "Marlene",
            "popularity": 0.5128205128205128
          },
          {
            "name": "Michelle",
            "popularity": 0.4911591355599214
          },
          {
            "name": "Renee",
            "popularity": 0.4875
          },
          {
            "name": "Sheryl",
            "popularity": 0.47580645161290325
          },
          {
            "name": "Shelly",
            "popularity": 0.46226415094339623
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Duane",
            "popularity": 1.064516129032258
          },
          {
            "name": "Gerald",
            "popularity": 0.9387755102040817
          },
          {
            "name": "Kim",
            "popularity": 0.8620689655172413
          },
          {
            "name": "Gordon",
            "popularity": 0.8554216867469879
          },
          {
            "name": "Dave",
            "popularity": 0.8235294117647058
          },
          {
            "name": "Lyle",
            "popularity": 0.8095238095238095
          },
          {
            "name": "Rick",
            "popularity": 0.784
          },
          {
            "name": "Darrin",
            "popularity": 0.7307692307692307
          },
          {
            "name": "Dale",
            "popularity": 0.6915584415584416
          },
          {
            "name": "Fredrick",
            "popularity": 0.6730769230769231
          },
          {
            "name": "Kurt",
            "popularity": 0.6162790697674418
          },
          {
            "name": "Kirk",
            "popularity": 0.6056338028169014
          },
          {
            "name": "Douglas",
            "popularity": 0.5559772296015181
          },
          {
            "name": "Dennis",
            "popularity": 0.5336463223787168
          },
          {
            "name": "Tim",
            "popularity": 0.5135135135135135
          }
        ]
      }
    ]
  },
  {
    "state": "MN",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Jodi",
            "popularity": 2.5454545454545454
          },
          {
            "name": "Jody",
            "popularity": 2.074626865671642
          },
          {
            "name": "Marcella",
            "popularity": 2
          },
          {
            "name": "Kristin",
            "popularity": 1.8656716417910448
          },
          {
            "name": "Roxanne",
            "popularity": 1.8615384615384616
          },
          {
            "name": "Kristine",
            "popularity": 1.7159090909090908
          },
          {
            "name": "Kristi",
            "popularity": 1.7115384615384615
          },
          {
            "name": "Colleen",
            "popularity": 1.553191489361702
          },
          {
            "name": "Harriet",
            "popularity": 1.5416666666666667
          },
          {
            "name": "Julie",
            "popularity": 1.472
          },
          {
            "name": "Lorraine",
            "popularity": 1.4065040650406504
          },
          {
            "name": "Heidi",
            "popularity": 1.393939393939394
          },
          {
            "name": "Delores",
            "popularity": 1.3243243243243243
          },
          {
            "name": "Shelly",
            "popularity": 1.320754716981132
          },
          {
            "name": "Marlene",
            "popularity": 1.2564102564102564
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Lyle",
            "popularity": 3.0793650793650795
          },
          {
            "name": "Duane",
            "popularity": 2.9193548387096775
          },
          {
            "name": "Bradley",
            "popularity": 2.6747967479674797
          },
          {
            "name": "Jerome",
            "popularity": 1.9597315436241611
          },
          {
            "name": "Dean",
            "popularity": 1.955128205128205
          },
          {
            "name": "Jason",
            "popularity": 1.8888888888888888
          },
          {
            "name": "Darin",
            "popularity": 1.6226415094339623
          },
          {
            "name": "Gordon",
            "popularity": 1.6204819277108433
          },
          {
            "name": "Todd",
            "popularity": 1.5364963503649636
          },
          {
            "name": "Jon",
            "popularity": 1.4689655172413794
          },
          {
            "name": "Troy",
            "popularity": 1.4296296296296296
          },
          {
            "name": "Dale",
            "popularity": 1.3993506493506493
          },
          {
            "name": "Arnold",
            "popularity": 1.3660714285714286
          },
          {
            "name": "Allan",
            "popularity": 1.2941176470588236
          },
          {
            "name": "Scott",
            "popularity": 1.2675521821631879
          }
        ]
      }
    ]
  },
  {
    "state": "MO",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Wilma",
            "popularity": 1.471264367816092
          },
          {
            "name": "Opal",
            "popularity": 1.1546391752577319
          },
          {
            "name": "Laverne",
            "popularity": 1.0727272727272728
          },
          {
            "name": "Velma",
            "popularity": 0.9313725490196079
          },
          {
            "name": "Marcella",
            "popularity": 0.8548387096774194
          },
          {
            "name": "Lana",
            "popularity": 0.8235294117647058
          },
          {
            "name": "Christy",
            "popularity": 0.803921568627451
          },
          {
            "name": "Beulah",
            "popularity": 0.7558139534883721
          },
          {
            "name": "Carla",
            "popularity": 0.7448275862068966
          },
          {
            "name": "Shelly",
            "popularity": 0.7358490566037735
          },
          {
            "name": "Glenda",
            "popularity": 0.7291666666666666
          },
          {
            "name": "Georgia",
            "popularity": 0.7185185185185186
          },
          {
            "name": "Norma",
            "popularity": 0.717391304347826
          },
          {
            "name": "Erma",
            "popularity": 0.7121212121212122
          },
          {
            "name": "Marsha",
            "popularity": 0.6438356164383562
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Virgil",
            "popularity": 1.3974358974358974
          },
          {
            "name": "Darin",
            "popularity": 1.1132075471698113
          },
          {
            "name": "Bob",
            "popularity": 1.0446428571428572
          },
          {
            "name": "Jackie",
            "popularity": 1.0212765957446808
          },
          {
            "name": "Everett",
            "popularity": 0.9102564102564102
          },
          {
            "name": "Delbert",
            "popularity": 0.9090909090909091
          },
          {
            "name": "Bill",
            "popularity": 0.8465608465608465
          },
          {
            "name": "Elmer",
            "popularity": 0.803030303030303
          },
          {
            "name": "Garry",
            "popularity": 0.7
          },
          {
            "name": "Vernon",
            "popularity": 0.6858974358974359
          },
          {
            "name": "Lloyd",
            "popularity": 0.6763005780346821
          },
          {
            "name": "Floyd",
            "popularity": 0.6666666666666666
          },
          {
            "name": "Oliver",
            "popularity": 0.6666666666666666
          },
          {
            "name": "Billy",
            "popularity": 0.6408977556109726
          },
          {
            "name": "Marion",
            "popularity": 0.6
          }
        ]
      }
    ]
  },
  {
    "state": "MS",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Rosie",
            "popularity": 8.402298850574713
          },
          {
            "name": "Annie",
            "popularity": 5.015576323987539
          },
          {
            "name": "Willie",
            "popularity": 4.903553299492386
          },
          {
            "name": "Bobbie",
            "popularity": 4.2
          },
          {
            "name": "Maggie",
            "popularity": 4.078125
          },
          {
            "name": "Mattie",
            "popularity": 4.051851851851852
          },
          {
            "name": "Katie",
            "popularity": 4.035714285714286
          },
          {
            "name": "Lillie",
            "popularity": 4
          },
          {
            "name": "Hattie",
            "popularity": 3.988235294117647
          },
          {
            "name": "Essie",
            "popularity": 3.9019607843137254
          },
          {
            "name": "Johnnie",
            "popularity": 3.824324324324324
          },
          {
            "name": "Lula",
            "popularity": 3.738095238095238
          },
          {
            "name": "Fannie",
            "popularity": 3.419753086419753
          },
          {
            "name": "Minnie",
            "popularity": 3.1755725190839694
          },
          {
            "name": "Jessie",
            "popularity": 3.0390625
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Willie",
            "popularity": 6.281837160751566
          },
          {
            "name": "Jessie",
            "popularity": 5.6020408163265305
          },
          {
            "name": "Johnnie",
            "popularity": 4.339285714285714
          },
          {
            "name": "Eddie",
            "popularity": 3.8629441624365484
          },
          {
            "name": "Earnest",
            "popularity": 3.7941176470588234
          },
          {
            "name": "Jimmie",
            "popularity": 3.744186046511628
          },
          {
            "name": "Charlie",
            "popularity": 3.734265734265734
          },
          {
            "name": "Bennie",
            "popularity": 3.5689655172413794
          },
          {
            "name": "Clifton",
            "popularity": 2.85
          },
          {
            "name": "Otis",
            "popularity": 2.8
          },
          {
            "name": "Luther",
            "popularity": 2.373134328358209
          },
          {
            "name": "Sam",
            "popularity": 2.349056603773585
          },
          {
            "name": "Freddie",
            "popularity": 2.1923076923076925
          },
          {
            "name": "Johnny",
            "popularity": 1.9598540145985401
          },
          {
            "name": "Lee",
            "popularity": 1.812807881773399
          }
        ]
      }
    ]
  },
  {
    "state": "MT",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Tami",
            "popularity": 2.6825396825396823
          },
          {
            "name": "Mabel",
            "popularity": 2.6666666666666665
          },
          {
            "name": "Pat",
            "popularity": 2.5925925925925926
          },
          {
            "name": "Jamie",
            "popularity": 2.5211267605633805
          },
          {
            "name": "Shelly",
            "popularity": 2.5
          },
          {
            "name": "Teri",
            "popularity": 2.417910447761194
          },
          {
            "name": "Olive",
            "popularity": 2.3846153846153846
          },
          {
            "name": "Karla",
            "popularity": 2.3015873015873014
          },
          {
            "name": "Kristi",
            "popularity": 2.1923076923076925
          },
          {
            "name": "Patti",
            "popularity": 2.1194029850746268
          },
          {
            "name": "Genevieve",
            "popularity": 2.1
          },
          {
            "name": "Colleen",
            "popularity": 1.929078014184397
          },
          {
            "name": "Shannon",
            "popularity": 1.9058823529411764
          },
          {
            "name": "Shelley",
            "popularity": 1.898876404494382
          },
          {
            "name": "Marlene",
            "popularity": 1.7820512820512822
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Kelly",
            "popularity": 3
          },
          {
            "name": "Lyle",
            "popularity": 2.7142857142857144
          },
          {
            "name": "Shawn",
            "popularity": 2.406779661016949
          },
          {
            "name": "Woodrow",
            "popularity": 2.2884615384615383
          },
          {
            "name": "Brett",
            "popularity": 2.136986301369863
          },
          {
            "name": "Jason",
            "popularity": 1.9722222222222223
          },
          {
            "name": "Brad",
            "popularity": 1.9487179487179487
          },
          {
            "name": "Darin",
            "popularity": 1.9245283018867925
          },
          {
            "name": "Duane",
            "popularity": 1.8870967741935485
          },
          {
            "name": "Darren",
            "popularity": 1.8144329896907216
          },
          {
            "name": "Kirk",
            "popularity": 1.7605633802816902
          },
          {
            "name": "Dan",
            "popularity": 1.7217391304347827
          },
          {
            "name": "Tim",
            "popularity": 1.6756756756756757
          },
          {
            "name": "Lance",
            "popularity": 1.625
          },
          {
            "name": "Rick",
            "popularity": 1.608
          }
        ]
      }
    ]
  },
  {
    "state": "NC",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Annie",
            "popularity": 3.015576323987539
          },
          {
            "name": "Maggie",
            "popularity": 2.3125
          },
          {
            "name": "Katie",
            "popularity": 2.142857142857143
          },
          {
            "name": "Hattie",
            "popularity": 2.1294117647058823
          },
          {
            "name": "Mamie",
            "popularity": 1.9726027397260273
          },
          {
            "name": "Sadie",
            "popularity": 1.8928571428571428
          },
          {
            "name": "Mable",
            "popularity": 1.6666666666666667
          },
          {
            "name": "Lillie",
            "popularity": 1.604026845637584
          },
          {
            "name": "Shelia",
            "popularity": 1.5569620253164558
          },
          {
            "name": "Rosa",
            "popularity": 1.5539568345323742
          },
          {
            "name": "Fannie",
            "popularity": 1.4691358024691359
          },
          {
            "name": "Hilda",
            "popularity": 1.4578313253012047
          },
          {
            "name": "Rachel",
            "popularity": 1.425
          },
          {
            "name": "Crystal",
            "popularity": 1.4137931034482758
          },
          {
            "name": "Daisy",
            "popularity": 1.4
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Charlie",
            "popularity": 2.7062937062937062
          },
          {
            "name": "Clifton",
            "popularity": 2.2
          },
          {
            "name": "Bobby",
            "popularity": 2.018348623853211
          },
          {
            "name": "Hubert",
            "popularity": 1.9692307692307693
          },
          {
            "name": "Luther",
            "popularity": 1.955223880597015
          },
          {
            "name": "Johnnie",
            "popularity": 1.6875
          },
          {
            "name": "Donnie",
            "popularity": 1.6865671641791045
          },
          {
            "name": "Horace",
            "popularity": 1.6451612903225807
          },
          {
            "name": "Clyde",
            "popularity": 1.423841059602649
          },
          {
            "name": "Claude",
            "popularity": 1.4175824175824177
          },
          {
            "name": "Willie",
            "popularity": 1.3736951983298538
          },
          {
            "name": "Johnny",
            "popularity": 1.3722627737226278
          },
          {
            "name": "Ricky",
            "popularity": 1.2862068965517242
          },
          {
            "name": "Jimmy",
            "popularity": 1.2664233576642336
          },
          {
            "name": "Marshall",
            "popularity": 1.1967213114754098
          }
        ]
      }
    ]
  },
  {
    "state": "ND",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Kristi",
            "popularity": 6.346153846153846
          },
          {
            "name": "Karla",
            "popularity": 5.428571428571429
          },
          {
            "name": "Violet",
            "popularity": 4.056603773584905
          },
          {
            "name": "Myrtle",
            "popularity": 3.6031746031746033
          },
          {
            "name": "Shelly",
            "popularity": 3.4716981132075473
          },
          {
            "name": "Viola",
            "popularity": 3.296875
          },
          {
            "name": "Roxanne",
            "popularity": 3.276923076923077
          },
          {
            "name": "Jodi",
            "popularity": 3.1363636363636362
          },
          {
            "name": "Marlene",
            "popularity": 3.1346153846153846
          },
          {
            "name": "Paulette",
            "popularity": 3.0434782608695654
          },
          {
            "name": "Olga",
            "popularity": 2.8529411764705883
          },
          {
            "name": "Hilda",
            "popularity": 2.8313253012048194
          },
          {
            "name": "Olive",
            "popularity": 2.6923076923076925
          },
          {
            "name": "Leona",
            "popularity": 2.650943396226415
          },
          {
            "name": "Delores",
            "popularity": 2.614864864864865
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Lyle",
            "popularity": 6.333333333333333
          },
          {
            "name": "Darin",
            "popularity": 6.132075471698113
          },
          {
            "name": "Troy",
            "popularity": 5.985185185185185
          },
          {
            "name": "Duane",
            "popularity": 5.838709677419355
          },
          {
            "name": "Kelly",
            "popularity": 3.625
          },
          {
            "name": "Brent",
            "popularity": 3.3048780487804876
          },
          {
            "name": "Darren",
            "popularity": 3.2061855670103094
          },
          {
            "name": "Bradley",
            "popularity": 2.991869918699187
          },
          {
            "name": "Lynn",
            "popularity": 2.966666666666667
          },
          {
            "name": "Jason",
            "popularity": 2.8333333333333335
          },
          {
            "name": "Arnold",
            "popularity": 2.5535714285714284
          },
          {
            "name": "Gordon",
            "popularity": 2.5301204819277108
          },
          {
            "name": "Vernon",
            "popularity": 2.5256410256410255
          },
          {
            "name": "Kim",
            "popularity": 2.4827586206896552
          },
          {
            "name": "Dean",
            "popularity": 2.4358974358974357
          }
        ]
      }
    ]
  },
  {
    "state": "NE",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Kristi",
            "popularity": 3.1923076923076925
          },
          {
            "name": "Opal",
            "popularity": 2.7422680412371134
          },
          {
            "name": "Erma",
            "popularity": 2.196969696969697
          },
          {
            "name": "Maxine",
            "popularity": 2.022727272727273
          },
          {
            "name": "Shelly",
            "popularity": 1.9339622641509433
          },
          {
            "name": "Jody",
            "popularity": 1.5223880597014925
          },
          {
            "name": "Tami",
            "popularity": 1.492063492063492
          },
          {
            "name": "Jodi",
            "popularity": 1.4090909090909092
          },
          {
            "name": "Julie",
            "popularity": 1.408
          },
          {
            "name": "Olive",
            "popularity": 1.4038461538461537
          },
          {
            "name": "Leona",
            "popularity": 1.3773584905660377
          },
          {
            "name": "Wilma",
            "popularity": 1.3563218390804597
          },
          {
            "name": "Kay",
            "popularity": 1.3057851239669422
          },
          {
            "name": "Deanna",
            "popularity": 1.2429906542056075
          },
          {
            "name": "Christy",
            "popularity": 1.2352941176470589
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Lyle",
            "popularity": 4.523809523809524
          },
          {
            "name": "Duane",
            "popularity": 2.4596774193548385
          },
          {
            "name": "Darin",
            "popularity": 2.3773584905660377
          },
          {
            "name": "Kent",
            "popularity": 2.1857142857142855
          },
          {
            "name": "Dean",
            "popularity": 1.814102564102564
          },
          {
            "name": "Dale",
            "popularity": 1.8051948051948052
          },
          {
            "name": "Bradley",
            "popularity": 1.8048780487804879
          },
          {
            "name": "Delbert",
            "popularity": 1.709090909090909
          },
          {
            "name": "Virgil",
            "popularity": 1.641025641025641
          },
          {
            "name": "Rex",
            "popularity": 1.631578947368421
          },
          {
            "name": "Troy",
            "popularity": 1.6074074074074074
          },
          {
            "name": "Lynn",
            "popularity": 1.55
          },
          {
            "name": "Kirk",
            "popularity": 1.4929577464788732
          },
          {
            "name": "Rick",
            "popularity": 1.408
          },
          {
            "name": "Kelly",
            "popularity": 1.4027777777777777
          }
        ]
      }
    ]
  },
  {
    "state": "NH",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Kristen",
            "popularity": 6.69811320754717
          },
          {
            "name": "Claire",
            "popularity": 6.2025316455696204
          },
          {
            "name": "Jeannette",
            "popularity": 4.926470588235294
          },
          {
            "name": "Priscilla",
            "popularity": 4.8625
          },
          {
            "name": "Heidi",
            "popularity": 3.888888888888889
          },
          {
            "name": "Blanche",
            "popularity": 3.8076923076923075
          },
          {
            "name": "Muriel",
            "popularity": 3.611940298507463
          },
          {
            "name": "Olive",
            "popularity": 3.3846153846153846
          },
          {
            "name": "Pauline",
            "popularity": 3.3132530120481927
          },
          {
            "name": "Nicole",
            "popularity": 2.7454545454545456
          },
          {
            "name": "Kristin",
            "popularity": 2.5970149253731343
          },
          {
            "name": "Sophie",
            "popularity": 2.5081967213114753
          },
          {
            "name": "Stella",
            "popularity": 2.4915254237288136
          },
          {
            "name": "Lorraine",
            "popularity": 2.1747967479674797
          },
          {
            "name": "Gertrude",
            "popularity": 2.1607142857142856
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Roland",
            "popularity": 7.726315789473684
          },
          {
            "name": "Maurice",
            "popularity": 6.010204081632653
          },
          {
            "name": "Gerard",
            "popularity": 5.152777777777778
          },
          {
            "name": "Dana",
            "popularity": 4.425925925925926
          },
          {
            "name": "Marc",
            "popularity": 3.1809523809523808
          },
          {
            "name": "Leo",
            "popularity": 2.687116564417178
          },
          {
            "name": "Normand",
            "popularity": 2.308641975308642
          },
          {
            "name": "Shawn",
            "popularity": 2.152542372881356
          },
          {
            "name": "Jonathan",
            "popularity": 2.135593220338983
          },
          {
            "name": "Peter",
            "popularity": 1.9781181619256019
          },
          {
            "name": "Norman",
            "popularity": 1.9575971731448762
          },
          {
            "name": "Roger",
            "popularity": 1.827659574468085
          },
          {
            "name": "Jason",
            "popularity": 1.625
          },
          {
            "name": "Bruce",
            "popularity": 1.491566265060241
          },
          {
            "name": "Scott",
            "popularity": 1.3434535104364327
          }
        ]
      }
    ]
  },
  {
    "state": "NJ",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Maryann",
            "popularity": 2.276315789473684
          },
          {
            "name": "Claire",
            "popularity": 1.8734177215189873
          },
          {
            "name": "Eileen",
            "popularity": 1.5776699029126213
          },
          {
            "name": "Antoinette",
            "popularity": 1.5256410256410255
          },
          {
            "name": "Angelina",
            "popularity": 1.5098039215686274
          },
          {
            "name": "Rosemarie",
            "popularity": 1.4179104477611941
          },
          {
            "name": "Madeline",
            "popularity": 1.28
          },
          {
            "name": "Maureen",
            "popularity": 1.2674418604651163
          },
          {
            "name": "Marianne",
            "popularity": 1.2142857142857142
          },
          {
            "name": "Michele",
            "popularity": 1.1476014760147601
          },
          {
            "name": "Doreen",
            "popularity": 1.1384615384615384
          },
          {
            "name": "Joan",
            "popularity": 1.0298507462686568
          },
          {
            "name": "Eleanor",
            "popularity": 0.9929078014184397
          },
          {
            "name": "Marion",
            "popularity": 0.9710144927536232
          },
          {
            "name": "Sophie",
            "popularity": 0.9672131147540983
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Nicholas",
            "popularity": 2.1463414634146343
          },
          {
            "name": "Angelo",
            "popularity": 1.9107142857142858
          },
          {
            "name": "Vincent",
            "popularity": 1.6712328767123288
          },
          {
            "name": "Peter",
            "popularity": 1.4923413566739605
          },
          {
            "name": "Salvatore",
            "popularity": 1.3146067415730338
          },
          {
            "name": "Alexander",
            "popularity": 1.2941176470588236
          },
          {
            "name": "Anthony",
            "popularity": 1.2300884955752212
          },
          {
            "name": "Gerard",
            "popularity": 1.1666666666666667
          },
          {
            "name": "Joseph",
            "popularity": 1.1478405315614617
          },
          {
            "name": "Frank",
            "popularity": 0.9502824858757062
          },
          {
            "name": "Louis",
            "popularity": 0.9310344827586207
          },
          {
            "name": "Frederick",
            "popularity": 0.8032128514056225
          },
          {
            "name": "Edward",
            "popularity": 0.7849117174959872
          },
          {
            "name": "Theodore",
            "popularity": 0.7846153846153846
          },
          {
            "name": "Andrew",
            "popularity": 0.7011173184357542
          }
        ]
      }
    ]
  },
  {
    "state": "NM",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Cecilia",
            "popularity": 6.017543859649122
          },
          {
            "name": "Ramona",
            "popularity": 4.694444444444445
          },
          {
            "name": "Carmen",
            "popularity": 4.421052631578948
          },
          {
            "name": "Bernadette",
            "popularity": 3.9649122807017543
          },
          {
            "name": "Maria",
            "popularity": 3.7816455696202533
          },
          {
            "name": "Lucy",
            "popularity": 3.5877862595419847
          },
          {
            "name": "Priscilla",
            "popularity": 3.5625
          },
          {
            "name": "Flora",
            "popularity": 2.953125
          },
          {
            "name": "Yolanda",
            "popularity": 2.7714285714285714
          },
          {
            "name": "Dora",
            "popularity": 2.67032967032967
          },
          {
            "name": "Marcella",
            "popularity": 2.6451612903225805
          },
          {
            "name": "Lydia",
            "popularity": 2.4210526315789473
          },
          {
            "name": "Lupe",
            "popularity": 2.2222222222222223
          },
          {
            "name": "Stella",
            "popularity": 2.1610169491525424
          },
          {
            "name": "Rosie",
            "popularity": 2.103448275862069
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Manuel",
            "popularity": 10.227272727272727
          },
          {
            "name": "Jose",
            "popularity": 7.42512077294686
          },
          {
            "name": "Antonio",
            "popularity": 5.476190476190476
          },
          {
            "name": "Gilbert",
            "popularity": 5.227642276422764
          },
          {
            "name": "Ruben",
            "popularity": 5.016393442622951
          },
          {
            "name": "Juan",
            "popularity": 4.850393700787402
          },
          {
            "name": "Carlos",
            "popularity": 4.291139240506329
          },
          {
            "name": "Joe",
            "popularity": 3.8333333333333335
          },
          {
            "name": "Pedro",
            "popularity": 2.8870967741935485
          },
          {
            "name": "Luis",
            "popularity": 2.776470588235294
          },
          {
            "name": "Alex",
            "popularity": 2.765625
          },
          {
            "name": "Francisco",
            "popularity": 2.75
          },
          {
            "name": "Miguel",
            "popularity": 2.740740740740741
          },
          {
            "name": "Jesus",
            "popularity": 2.6666666666666665
          },
          {
            "name": "Bennie",
            "popularity": 2.5172413793103448
          }
        ]
      }
    ]
  },
  {
    "state": "NV",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Olga",
            "popularity": 5.102941176470588
          },
          {
            "name": "Traci",
            "popularity": 4.338709677419355
          },
          {
            "name": "Shannon",
            "popularity": 4.2
          },
          {
            "name": "Stacey",
            "popularity": 4.148148148148148
          },
          {
            "name": "Pat",
            "popularity": 3.9814814814814814
          },
          {
            "name": "Toni",
            "popularity": 3.1648351648351647
          },
          {
            "name": "Natalie",
            "popularity": 3.15
          },
          {
            "name": "Teri",
            "popularity": 3.014925373134328
          },
          {
            "name": "Kelli",
            "popularity": 2.981818181818182
          },
          {
            "name": "Marguerite",
            "popularity": 2.9473684210526314
          },
          {
            "name": "Tina",
            "popularity": 2.8875
          },
          {
            "name": "Blanche",
            "popularity": 2.7948717948717947
          },
          {
            "name": "Tami",
            "popularity": 2.746031746031746
          },
          {
            "name": "Nicole",
            "popularity": 2.7454545454545456
          },
          {
            "name": "Leslie",
            "popularity": 2.672727272727273
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Jason",
            "popularity": 4.402777777777778
          },
          {
            "name": "Shawn",
            "popularity": 4.1440677966101696
          },
          {
            "name": "Troy",
            "popularity": 4.014814814814815
          },
          {
            "name": "Kelly",
            "popularity": 3.736111111111111
          },
          {
            "name": "Woodrow",
            "popularity": 3.6538461538461537
          },
          {
            "name": "Lance",
            "popularity": 2.982142857142857
          },
          {
            "name": "Darren",
            "popularity": 2.711340206185567
          },
          {
            "name": "Mike",
            "popularity": 2.526086956521739
          },
          {
            "name": "Brent",
            "popularity": 2
          },
          {
            "name": "Adam",
            "popularity": 2
          },
          {
            "name": "Brett",
            "popularity": 1.9863013698630136
          },
          {
            "name": "Aaron",
            "popularity": 1.972972972972973
          },
          {
            "name": "Darin",
            "popularity": 1.9433962264150944
          },
          {
            "name": "Delbert",
            "popularity": 1.8909090909090909
          },
          {
            "name": "Tracy",
            "popularity": 1.639344262295082
          }
        ]
      }
    ]
  },
  {
    "state": "NY",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Antoinette",
            "popularity": 1.7564102564102564
          },
          {
            "name": "Eileen",
            "popularity": 1.674757281553398
          },
          {
            "name": "Madeline",
            "popularity": 1.6533333333333333
          },
          {
            "name": "Miriam",
            "popularity": 1.618421052631579
          },
          {
            "name": "Muriel",
            "popularity": 1.5671641791044777
          },
          {
            "name": "Angelina",
            "popularity": 1.5490196078431373
          },
          {
            "name": "Rosemarie",
            "popularity": 1.462686567164179
          },
          {
            "name": "Maureen",
            "popularity": 1.3546511627906976
          },
          {
            "name": "Maryann",
            "popularity": 1.1578947368421053
          },
          {
            "name": "Marion",
            "popularity": 1
          },
          {
            "name": "Josephine",
            "popularity": 1
          },
          {
            "name": "Claire",
            "popularity": 0.9873417721518988
          },
          {
            "name": "Anne",
            "popularity": 0.9867109634551495
          },
          {
            "name": "Joan",
            "popularity": 0.9154228855721394
          },
          {
            "name": "Doreen",
            "popularity": 0.9076923076923077
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Salvatore",
            "popularity": 2.258426966292135
          },
          {
            "name": "Angelo",
            "popularity": 2.0535714285714284
          },
          {
            "name": "Vincent",
            "popularity": 1.9634703196347032
          },
          {
            "name": "Nicholas",
            "popularity": 1.7967479674796747
          },
          {
            "name": "Gerard",
            "popularity": 1.7916666666666667
          },
          {
            "name": "Peter",
            "popularity": 1.687089715536105
          },
          {
            "name": "Stuart",
            "popularity": 1.2096774193548387
          },
          {
            "name": "Anthony",
            "popularity": 1.1843657817109146
          },
          {
            "name": "Seymour",
            "popularity": 1.1296296296296295
          },
          {
            "name": "Alexander",
            "popularity": 1.035294117647059
          },
          {
            "name": "Martin",
            "popularity": 0.9146341463414634
          },
          {
            "name": "Neil",
            "popularity": 0.9078947368421053
          },
          {
            "name": "Philip",
            "popularity": 0.8896551724137931
          },
          {
            "name": "Louis",
            "popularity": 0.8488063660477454
          },
          {
            "name": "Sidney",
            "popularity": 0.8461538461538461
          }
        ]
      }
    ]
  },
  {
    "state": "OH",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Beth",
            "popularity": 0.6778523489932886
          },
          {
            "name": "Patty",
            "popularity": 0.6506024096385542
          },
          {
            "name": "Sue",
            "popularity": 0.6379310344827587
          },
          {
            "name": "Amy",
            "popularity": 0.5906976744186047
          },
          {
            "name": "Marcella",
            "popularity": 0.5
          },
          {
            "name": "Dianna",
            "popularity": 0.45588235294117646
          },
          {
            "name": "Becky",
            "popularity": 0.44954128440366975
          },
          {
            "name": "Tonya",
            "popularity": 0.43333333333333335
          },
          {
            "name": "Kimberly",
            "popularity": 0.42205882352941176
          },
          {
            "name": "Rosemary",
            "popularity": 0.40588235294117647
          },
          {
            "name": "Marcia",
            "popularity": 0.3974358974358974
          },
          {
            "name": "Darla",
            "popularity": 0.39655172413793105
          },
          {
            "name": "Penny",
            "popularity": 0.3937007874015748
          },
          {
            "name": "Sandy",
            "popularity": 0.3924050632911392
          },
          {
            "name": "Marilyn",
            "popularity": 0.3897550111358575
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Rick",
            "popularity": 0.776
          },
          {
            "name": "Tim",
            "popularity": 0.7027027027027027
          },
          {
            "name": "Dave",
            "popularity": 0.6617647058823529
          },
          {
            "name": "Dale",
            "popularity": 0.5974025974025974
          },
          {
            "name": "Wilbur",
            "popularity": 0.5873015873015873
          },
          {
            "name": "Darrin",
            "popularity": 0.5192307692307693
          },
          {
            "name": "Jeffrey",
            "popularity": 0.4994152046783626
          },
          {
            "name": "Tom",
            "popularity": 0.4934210526315789
          },
          {
            "name": "Timothy",
            "popularity": 0.4835007173601148
          },
          {
            "name": "Jeffery",
            "popularity": 0.47520661157024796
          },
          {
            "name": "Jeff",
            "popularity": 0.4304635761589404
          },
          {
            "name": "Ted",
            "popularity": 0.41025641025641024
          },
          {
            "name": "Karl",
            "popularity": 0.36904761904761907
          },
          {
            "name": "Carl",
            "popularity": 0.3557312252964427
          },
          {
            "name": "Dwight",
            "popularity": 0.35135135135135137
          }
        ]
      }
    ]
  },
  {
    "state": "OK",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Opal",
            "popularity": 4.134020618556701
          },
          {
            "name": "Billie",
            "popularity": 3.706422018348624
          },
          {
            "name": "Shelly",
            "popularity": 2.4056603773584904
          },
          {
            "name": "Velma",
            "popularity": 2.196078431372549
          },
          {
            "name": "Kristi",
            "popularity": 2.1923076923076925
          },
          {
            "name": "Patsy",
            "popularity": 2.1538461538461537
          },
          {
            "name": "Darla",
            "popularity": 2.1379310344827585
          },
          {
            "name": "Wanda",
            "popularity": 2.1143695014662756
          },
          {
            "name": "Wilma",
            "popularity": 1.9310344827586208
          },
          {
            "name": "Geneva",
            "popularity": 1.7857142857142858
          },
          {
            "name": "Lola",
            "popularity": 1.7647058823529411
          },
          {
            "name": "Juanita",
            "popularity": 1.7043478260869565
          },
          {
            "name": "Erma",
            "popularity": 1.6818181818181819
          },
          {
            "name": "Kelli",
            "popularity": 1.6545454545454545
          },
          {
            "name": "Ruby",
            "popularity": 1.608695652173913
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Billy",
            "popularity": 3.134663341645885
          },
          {
            "name": "Jackie",
            "popularity": 2.7127659574468086
          },
          {
            "name": "Jimmie",
            "popularity": 2.5426356589147288
          },
          {
            "name": "Jimmy",
            "popularity": 2.3795620437956204
          },
          {
            "name": "Tommy",
            "popularity": 2.2923976608187133
          },
          {
            "name": "Bill",
            "popularity": 2.2433862433862433
          },
          {
            "name": "Cecil",
            "popularity": 2.1478260869565218
          },
          {
            "name": "Bobby",
            "popularity": 2.110091743119266
          },
          {
            "name": "Delbert",
            "popularity": 2.036363636363636
          },
          {
            "name": "Bob",
            "popularity": 1.9642857142857142
          },
          {
            "name": "Virgil",
            "popularity": 1.8205128205128205
          },
          {
            "name": "Floyd",
            "popularity": 1.7515151515151515
          },
          {
            "name": "Rickey",
            "popularity": 1.6704545454545454
          },
          {
            "name": "Don",
            "popularity": 1.53475935828877
          },
          {
            "name": "Ronnie",
            "popularity": 1.471698113207547
          }
        ]
      }
    ]
  },
  {
    "state": "OR",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Tami",
            "popularity": 3.0952380952380953
          },
          {
            "name": "Shannon",
            "popularity": 2.6470588235294117
          },
          {
            "name": "Shelley",
            "popularity": 1.9438202247191012
          },
          {
            "name": "Julie",
            "popularity": 1.912
          },
          {
            "name": "Kristi",
            "popularity": 1.9038461538461537
          },
          {
            "name": "Tamara",
            "popularity": 1.882882882882883
          },
          {
            "name": "Lucile",
            "popularity": 1.694915254237288
          },
          {
            "name": "Shelly",
            "popularity": 1.679245283018868
          },
          {
            "name": "Jan",
            "popularity": 1.5569620253164558
          },
          {
            "name": "Becky",
            "popularity": 1.4770642201834863
          },
          {
            "name": "Deanna",
            "popularity": 1.4485981308411215
          },
          {
            "name": "Kelli",
            "popularity": 1.4363636363636363
          },
          {
            "name": "Teri",
            "popularity": 1.4328358208955223
          },
          {
            "name": "Karla",
            "popularity": 1.4126984126984128
          },
          {
            "name": "Traci",
            "popularity": 1.3709677419354838
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Darin",
            "popularity": 2.981132075471698
          },
          {
            "name": "Woodrow",
            "popularity": 2.75
          },
          {
            "name": "Kelly",
            "popularity": 2.5833333333333335
          },
          {
            "name": "Rick",
            "popularity": 2.16
          },
          {
            "name": "Jason",
            "popularity": 2.0277777777777777
          },
          {
            "name": "Jim",
            "popularity": 1.8488372093023255
          },
          {
            "name": "Bob",
            "popularity": 1.7857142857142858
          },
          {
            "name": "Dan",
            "popularity": 1.7304347826086957
          },
          {
            "name": "Dave",
            "popularity": 1.6176470588235294
          },
          {
            "name": "Brad",
            "popularity": 1.6025641025641026
          },
          {
            "name": "Delbert",
            "popularity": 1.6
          },
          {
            "name": "Jeff",
            "popularity": 1.5894039735099337
          },
          {
            "name": "Mike",
            "popularity": 1.5565217391304347
          },
          {
            "name": "Lyle",
            "popularity": 1.5238095238095237
          },
          {
            "name": "Bradley",
            "popularity": 1.5121951219512195
          }
        ]
      }
    ]
  },
  {
    "state": "PA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Anna",
            "popularity": 1.387900355871886
          },
          {
            "name": "Dolores",
            "popularity": 1.1302681992337165
          },
          {
            "name": "Maryann",
            "popularity": 1.0526315789473684
          },
          {
            "name": "Eleanor",
            "popularity": 0.9787234042553191
          },
          {
            "name": "Miriam",
            "popularity": 0.9736842105263158
          },
          {
            "name": "Bernadette",
            "popularity": 0.9649122807017544
          },
          {
            "name": "Marian",
            "popularity": 0.7484276729559748
          },
          {
            "name": "Sophie",
            "popularity": 0.7377049180327869
          },
          {
            "name": "Rosemarie",
            "popularity": 0.7164179104477612
          },
          {
            "name": "Agnes",
            "popularity": 0.7
          },
          {
            "name": "Helen",
            "popularity": 0.6921692169216922
          },
          {
            "name": "Florence",
            "popularity": 0.6865203761755486
          },
          {
            "name": "Stella",
            "popularity": 0.6271186440677966
          },
          {
            "name": "Joanne",
            "popularity": 0.6220472440944882
          },
          {
            "name": "Marianne",
            "popularity": 0.6
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Francis",
            "popularity": 1.394648829431438
          },
          {
            "name": "Harry",
            "popularity": 1.1466346153846154
          },
          {
            "name": "Joseph",
            "popularity": 1.012735326688815
          },
          {
            "name": "Nicholas",
            "popularity": 0.9186991869918699
          },
          {
            "name": "Barry",
            "popularity": 0.7129629629629629
          },
          {
            "name": "Bernard",
            "popularity": 0.6682242990654206
          },
          {
            "name": "Vincent",
            "popularity": 0.5981735159817352
          },
          {
            "name": "Edward",
            "popularity": 0.5947030497592295
          },
          {
            "name": "Andrew",
            "popularity": 0.5558659217877095
          },
          {
            "name": "Samuel",
            "popularity": 0.5517241379310345
          },
          {
            "name": "Theodore",
            "popularity": 0.5282051282051282
          },
          {
            "name": "Alexander",
            "popularity": 0.4823529411764706
          },
          {
            "name": "Albert",
            "popularity": 0.46331236897274636
          },
          {
            "name": "Stanley",
            "popularity": 0.4523076923076923
          },
          {
            "name": "Frank",
            "popularity": 0.4406779661016949
          }
        ]
      }
    ]
  },
  {
    "state": "RI",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Claire",
            "popularity": 7.050632911392405
          },
          {
            "name": "Kristen",
            "popularity": 4.245283018867925
          },
          {
            "name": "Muriel",
            "popularity": 4.164179104477612
          },
          {
            "name": "Angelina",
            "popularity": 4.098039215686274
          },
          {
            "name": "Doreen",
            "popularity": 3.4153846153846152
          },
          {
            "name": "Maureen",
            "popularity": 3.2209302325581395
          },
          {
            "name": "Jeannette",
            "popularity": 3.014705882352941
          },
          {
            "name": "Madeline",
            "popularity": 2.493333333333333
          },
          {
            "name": "Flora",
            "popularity": 2.3125
          },
          {
            "name": "Jennie",
            "popularity": 2.288659793814433
          },
          {
            "name": "Gertrude",
            "popularity": 2.2083333333333335
          },
          {
            "name": "Laurie",
            "popularity": 2.103139013452915
          },
          {
            "name": "Gail",
            "popularity": 2.0113636363636362
          },
          {
            "name": "Olga",
            "popularity": 1.9705882352941178
          },
          {
            "name": "Sophie",
            "popularity": 1.9508196721311475
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Roland",
            "popularity": 4.2631578947368425
          },
          {
            "name": "Gerard",
            "popularity": 3.1666666666666665
          },
          {
            "name": "Normand",
            "popularity": 2.9012345679012346
          },
          {
            "name": "Angelo",
            "popularity": 2.357142857142857
          },
          {
            "name": "Leo",
            "popularity": 2.3067484662576687
          },
          {
            "name": "Marc",
            "popularity": 2.2857142857142856
          },
          {
            "name": "Alfred",
            "popularity": 1.9681274900398407
          },
          {
            "name": "Peter",
            "popularity": 1.8927789934354486
          },
          {
            "name": "Manuel",
            "popularity": 1.8181818181818181
          },
          {
            "name": "Raymond",
            "popularity": 1.766490765171504
          },
          {
            "name": "Francis",
            "popularity": 1.6421404682274248
          },
          {
            "name": "Maurice",
            "popularity": 1.5510204081632653
          },
          {
            "name": "Vincent",
            "popularity": 1.5205479452054795
          },
          {
            "name": "Antonio",
            "popularity": 1.4761904761904763
          },
          {
            "name": "Anthony",
            "popularity": 1.3200589970501475
          }
        ]
      }
    ]
  },
  {
    "state": "SC",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Hattie",
            "popularity": 4.223529411764706
          },
          {
            "name": "Rosa",
            "popularity": 4.093525179856115
          },
          {
            "name": "Maggie",
            "popularity": 3.984375
          },
          {
            "name": "Janie",
            "popularity": 3.948717948717949
          },
          {
            "name": "Annie",
            "popularity": 3.8161993769470404
          },
          {
            "name": "Mamie",
            "popularity": 3.7534246575342465
          },
          {
            "name": "Daisy",
            "popularity": 3.5428571428571427
          },
          {
            "name": "Lillie",
            "popularity": 3.51006711409396
          },
          {
            "name": "Sadie",
            "popularity": 3.125
          },
          {
            "name": "Carrie",
            "popularity": 3.1142857142857143
          },
          {
            "name": "Essie",
            "popularity": 2.803921568627451
          },
          {
            "name": "Lula",
            "popularity": 2.6904761904761907
          },
          {
            "name": "Mattie",
            "popularity": 2.6296296296296298
          },
          {
            "name": "Willie",
            "popularity": 2.4060913705583755
          },
          {
            "name": "Jessie",
            "popularity": 2.265625
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Marion",
            "popularity": 4.8875
          },
          {
            "name": "Nathaniel",
            "popularity": 4.375
          },
          {
            "name": "Willie",
            "popularity": 3.9478079331941545
          },
          {
            "name": "Woodrow",
            "popularity": 2.826923076923077
          },
          {
            "name": "Luther",
            "popularity": 2.716417910447761
          },
          {
            "name": "Johnnie",
            "popularity": 2.5892857142857144
          },
          {
            "name": "Julius",
            "popularity": 2.5714285714285716
          },
          {
            "name": "Leroy",
            "popularity": 2.5069767441860464
          },
          {
            "name": "Charlie",
            "popularity": 2.3986013986013988
          },
          {
            "name": "Bennie",
            "popularity": 2.3448275862068964
          },
          {
            "name": "Freddie",
            "popularity": 2.1538461538461537
          },
          {
            "name": "Otis",
            "popularity": 2.1333333333333333
          },
          {
            "name": "Horace",
            "popularity": 2.0806451612903225
          },
          {
            "name": "Ben",
            "popularity": 1.7611940298507462
          },
          {
            "name": "Benjamin",
            "popularity": 1.7483443708609272
          }
        ]
      }
    ]
  },
  {
    "state": "SD",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Kristi",
            "popularity": 4.403846153846154
          },
          {
            "name": "Karla",
            "popularity": 3.9365079365079363
          },
          {
            "name": "Darla",
            "popularity": 3.3620689655172415
          },
          {
            "name": "Tamara",
            "popularity": 2.774774774774775
          },
          {
            "name": "Jody",
            "popularity": 2.611940298507463
          },
          {
            "name": "Violet",
            "popularity": 2.5660377358490565
          },
          {
            "name": "Mabel",
            "popularity": 2.5588235294117645
          },
          {
            "name": "Kay",
            "popularity": 2.512396694214876
          },
          {
            "name": "Delores",
            "popularity": 2.439189189189189
          },
          {
            "name": "Maxine",
            "popularity": 2.3484848484848486
          },
          {
            "name": "Verna",
            "popularity": 2.2837837837837838
          },
          {
            "name": "Viola",
            "popularity": 2.28125
          },
          {
            "name": "Olive",
            "popularity": 2.173076923076923
          },
          {
            "name": "Leona",
            "popularity": 2.169811320754717
          },
          {
            "name": "Lana",
            "popularity": 2.0784313725490198
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Lyle",
            "popularity": 7.285714285714286
          },
          {
            "name": "Darin",
            "popularity": 4.962264150943396
          },
          {
            "name": "Kelly",
            "popularity": 4.236111111111111
          },
          {
            "name": "Duane",
            "popularity": 4.088709677419355
          },
          {
            "name": "Bradley",
            "popularity": 3.2113821138211383
          },
          {
            "name": "Brad",
            "popularity": 2.641025641025641
          },
          {
            "name": "Troy",
            "popularity": 2.5555555555555554
          },
          {
            "name": "Todd",
            "popularity": 2.4306569343065694
          },
          {
            "name": "Delbert",
            "popularity": 2.3636363636363638
          },
          {
            "name": "Dean",
            "popularity": 2.301282051282051
          },
          {
            "name": "Dale",
            "popularity": 2.2305194805194803
          },
          {
            "name": "Elmer",
            "popularity": 1.9090909090909092
          },
          {
            "name": "Daryl",
            "popularity": 1.896551724137931
          },
          {
            "name": "Kim",
            "popularity": 1.8620689655172413
          },
          {
            "name": "Virgil",
            "popularity": 1.858974358974359
          }
        ]
      }
    ]
  },
  {
    "state": "TN",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Shelia",
            "popularity": 2.7721518987341773
          },
          {
            "name": "Bobbie",
            "popularity": 1.82
          },
          {
            "name": "Wilma",
            "popularity": 1.5689655172413792
          },
          {
            "name": "Ruby",
            "popularity": 1.562111801242236
          },
          {
            "name": "Patsy",
            "popularity": 1.5384615384615385
          },
          {
            "name": "Billie",
            "popularity": 1.4770642201834863
          },
          {
            "name": "Mattie",
            "popularity": 1.451851851851852
          },
          {
            "name": "Glenda",
            "popularity": 1.4027777777777777
          },
          {
            "name": "Geneva",
            "popularity": 1.3979591836734695
          },
          {
            "name": "Willie",
            "popularity": 1.3908629441624365
          },
          {
            "name": "Maggie",
            "popularity": 1.375
          },
          {
            "name": "Melissa",
            "popularity": 1.251082251082251
          },
          {
            "name": "Wanda",
            "popularity": 1.2287390029325513
          },
          {
            "name": "Tonya",
            "popularity": 1.211111111111111
          },
          {
            "name": "Johnnie",
            "popularity": 1.2027027027027026
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Billy",
            "popularity": 2.3840399002493764
          },
          {
            "name": "Jackie",
            "popularity": 2.265957446808511
          },
          {
            "name": "Bobby",
            "popularity": 2.214067278287462
          },
          {
            "name": "Rickey",
            "popularity": 2.0113636363636362
          },
          {
            "name": "Donnie",
            "popularity": 1.9701492537313432
          },
          {
            "name": "Jimmy",
            "popularity": 1.905109489051095
          },
          {
            "name": "Ronnie",
            "popularity": 1.7169811320754718
          },
          {
            "name": "Hubert",
            "popularity": 1.6
          },
          {
            "name": "Luther",
            "popularity": 1.5970149253731343
          },
          {
            "name": "Claude",
            "popularity": 1.5384615384615385
          },
          {
            "name": "Tommy",
            "popularity": 1.5029239766081872
          },
          {
            "name": "Johnny",
            "popularity": 1.4817518248175183
          },
          {
            "name": "Ricky",
            "popularity": 1.4793103448275862
          },
          {
            "name": "Hugh",
            "popularity": 1.4050632911392404
          },
          {
            "name": "Charlie",
            "popularity": 1.2797202797202798
          }
        ]
      }
    ]
  },
  {
    "state": "TX",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Maria",
            "popularity": 5.031645569620253
          },
          {
            "name": "Guadalupe",
            "popularity": 2.7444444444444445
          },
          {
            "name": "Yolanda",
            "popularity": 2.6952380952380954
          },
          {
            "name": "Billie",
            "popularity": 2.4954128440366974
          },
          {
            "name": "Irma",
            "popularity": 2.364864864864865
          },
          {
            "name": "Rosa",
            "popularity": 2.338129496402878
          },
          {
            "name": "Alicia",
            "popularity": 2.303030303030303
          },
          {
            "name": "Janie",
            "popularity": 2.1794871794871793
          },
          {
            "name": "Dora",
            "popularity": 1.835164835164835
          },
          {
            "name": "Olga",
            "popularity": 1.7794117647058822
          },
          {
            "name": "Bobbie",
            "popularity": 1.6
          },
          {
            "name": "Patsy",
            "popularity": 1.5961538461538463
          },
          {
            "name": "Carmen",
            "popularity": 1.5894736842105264
          },
          {
            "name": "Lydia",
            "popularity": 1.5789473684210527
          },
          {
            "name": "Juanita",
            "popularity": 1.5521739130434782
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Juan",
            "popularity": 5.606299212598425
          },
          {
            "name": "Jose",
            "popularity": 4.903381642512077
          },
          {
            "name": "Ruben",
            "popularity": 4.508196721311475
          },
          {
            "name": "Manuel",
            "popularity": 4.036363636363636
          },
          {
            "name": "Jesus",
            "popularity": 3.764705882352941
          },
          {
            "name": "Pedro",
            "popularity": 3.6774193548387095
          },
          {
            "name": "Ricardo",
            "popularity": 3.5272727272727273
          },
          {
            "name": "Raul",
            "popularity": 3.4927536231884058
          },
          {
            "name": "Roberto",
            "popularity": 3.4857142857142858
          },
          {
            "name": "Carlos",
            "popularity": 3.3164556962025316
          },
          {
            "name": "Francisco",
            "popularity": 3.3088235294117645
          },
          {
            "name": "Antonio",
            "popularity": 3.2738095238095237
          },
          {
            "name": "Hector",
            "popularity": 2.5283018867924527
          },
          {
            "name": "Guadalupe",
            "popularity": 2.476923076923077
          },
          {
            "name": "Joe",
            "popularity": 2.1277056277056277
          }
        ]
      }
    ]
  },
  {
    "state": "UT",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Robyn",
            "popularity": 5.60377358490566
          },
          {
            "name": "Sherrie",
            "popularity": 4.568627450980392
          },
          {
            "name": "Kristine",
            "popularity": 3.340909090909091
          },
          {
            "name": "Erma",
            "popularity": 3.1818181818181817
          },
          {
            "name": "Natalie",
            "popularity": 3.1666666666666665
          },
          {
            "name": "Becky",
            "popularity": 3.0275229357798166
          },
          {
            "name": "Colleen",
            "popularity": 3.0141843971631204
          },
          {
            "name": "Jan",
            "popularity": 2.962025316455696
          },
          {
            "name": "Julie",
            "popularity": 2.744
          },
          {
            "name": "Jody",
            "popularity": 2.373134328358209
          },
          {
            "name": "Heidi",
            "popularity": 2.292929292929293
          },
          {
            "name": "Lucile",
            "popularity": 2.2203389830508473
          },
          {
            "name": "Leslie",
            "popularity": 2.175757575757576
          },
          {
            "name": "Teri",
            "popularity": 2.1044776119402986
          },
          {
            "name": "Shelly",
            "popularity": 2.0943396226415096
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Brent",
            "popularity": 10.182926829268293
          },
          {
            "name": "Lynn",
            "popularity": 9
          },
          {
            "name": "Kent",
            "popularity": 7.171428571428572
          },
          {
            "name": "Kelly",
            "popularity": 7.111111111111111
          },
          {
            "name": "Kim",
            "popularity": 5.931034482758621
          },
          {
            "name": "Darin",
            "popularity": 5.528301886792453
          },
          {
            "name": "Woodrow",
            "popularity": 5.365384615384615
          },
          {
            "name": "Brad",
            "popularity": 4.487179487179487
          },
          {
            "name": "Max",
            "popularity": 4.123287671232877
          },
          {
            "name": "Troy",
            "popularity": 4.029629629629629
          },
          {
            "name": "Rex",
            "popularity": 3.9298245614035086
          },
          {
            "name": "Tracy",
            "popularity": 3.2459016393442623
          },
          {
            "name": "Kerry",
            "popularity": 3.0344827586206895
          },
          {
            "name": "Don",
            "popularity": 2.978609625668449
          },
          {
            "name": "Jay",
            "popularity": 2.9545454545454546
          }
        ]
      }
    ]
  },
  {
    "state": "VA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Nannie",
            "popularity": 1.721311475409836
          },
          {
            "name": "Vanessa",
            "popularity": 1.510204081632653
          },
          {
            "name": "Rosa",
            "popularity": 1.330935251798561
          },
          {
            "name": "Shelia",
            "popularity": 1.3291139240506329
          },
          {
            "name": "Lucy",
            "popularity": 1.2290076335877862
          },
          {
            "name": "Fannie",
            "popularity": 1.0617283950617284
          },
          {
            "name": "Elsie",
            "popularity": 1.0545454545454545
          },
          {
            "name": "Susie",
            "popularity": 1.051948051948052
          },
          {
            "name": "Thelma",
            "popularity": 0.9695817490494296
          },
          {
            "name": "Hattie",
            "popularity": 0.9647058823529412
          },
          {
            "name": "Iris",
            "popularity": 0.9642857142857143
          },
          {
            "name": "Nellie",
            "popularity": 0.9618320610687023
          },
          {
            "name": "Angela",
            "popularity": 0.9276729559748428
          },
          {
            "name": "Virginia",
            "popularity": 0.9202702702702703
          },
          {
            "name": "Estelle",
            "popularity": 0.9090909090909091
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Charlie",
            "popularity": 1.7622377622377623
          },
          {
            "name": "Clifton",
            "popularity": 1.6833333333333333
          },
          {
            "name": "Claude",
            "popularity": 1.6263736263736264
          },
          {
            "name": "Lewis",
            "popularity": 1.4722222222222223
          },
          {
            "name": "Luther",
            "popularity": 1.4029850746268657
          },
          {
            "name": "Calvin",
            "popularity": 1.2380952380952381
          },
          {
            "name": "Earnest",
            "popularity": 1.1911764705882353
          },
          {
            "name": "Otis",
            "popularity": 1.1833333333333333
          },
          {
            "name": "Marshall",
            "popularity": 1.1147540983606556
          },
          {
            "name": "Cecil",
            "popularity": 1.1130434782608696
          },
          {
            "name": "Nelson",
            "popularity": 1.0892857142857142
          },
          {
            "name": "Reginald",
            "popularity": 1.0506329113924051
          },
          {
            "name": "Franklin",
            "popularity": 1.0327868852459017
          },
          {
            "name": "Woodrow",
            "popularity": 1.0192307692307692
          },
          {
            "name": "Clarence",
            "popularity": 0.9739413680781759
          }
        ]
      }
    ]
  },
  {
    "state": "VT",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Madeline",
            "popularity": 4.8
          },
          {
            "name": "Marion",
            "popularity": 4.1352657004830915
          },
          {
            "name": "Laurie",
            "popularity": 4.013452914798206
          },
          {
            "name": "Blanche",
            "popularity": 3.9358974358974357
          },
          {
            "name": "Claire",
            "popularity": 3.481012658227848
          },
          {
            "name": "Olive",
            "popularity": 3
          },
          {
            "name": "Priscilla",
            "popularity": 2.9125
          },
          {
            "name": "Heather",
            "popularity": 2.835294117647059
          },
          {
            "name": "Heidi",
            "popularity": 2.7373737373737375
          },
          {
            "name": "Pauline",
            "popularity": 2.2771084337349397
          },
          {
            "name": "Penny",
            "popularity": 2.2755905511811023
          },
          {
            "name": "Marguerite",
            "popularity": 2.2736842105263158
          },
          {
            "name": "Muriel",
            "popularity": 2.2686567164179103
          },
          {
            "name": "Tina",
            "popularity": 2.245833333333333
          },
          {
            "name": "Jeannette",
            "popularity": 2.161764705882353
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Jason",
            "popularity": 4.125
          },
          {
            "name": "Reginald",
            "popularity": 3.6962025316455698
          },
          {
            "name": "Maurice",
            "popularity": 3.693877551020408
          },
          {
            "name": "Roland",
            "popularity": 3.3789473684210525
          },
          {
            "name": "Dana",
            "popularity": 3.314814814814815
          },
          {
            "name": "Wendell",
            "popularity": 2.660377358490566
          },
          {
            "name": "Francis",
            "popularity": 2.6387959866220734
          },
          {
            "name": "Bernard",
            "popularity": 2.4953271028037385
          },
          {
            "name": "Gordon",
            "popularity": 2.4518072289156625
          },
          {
            "name": "Everett",
            "popularity": 2.2435897435897436
          },
          {
            "name": "Shawn",
            "popularity": 2.1440677966101696
          },
          {
            "name": "Sean",
            "popularity": 2.12396694214876
          },
          {
            "name": "Clayton",
            "popularity": 2
          },
          {
            "name": "Kim",
            "popularity": 1.793103448275862
          },
          {
            "name": "Todd",
            "popularity": 1.7627737226277371
          }
        ]
      }
    ]
  },
  {
    "state": "WA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Tami",
            "popularity": 2.9682539682539684
          },
          {
            "name": "Shannon",
            "popularity": 2.2
          },
          {
            "name": "Kristi",
            "popularity": 1.7884615384615385
          },
          {
            "name": "Heidi",
            "popularity": 1.707070707070707
          },
          {
            "name": "Olive",
            "popularity": 1.6730769230769231
          },
          {
            "name": "Shelley",
            "popularity": 1.6629213483146068
          },
          {
            "name": "Kelli",
            "popularity": 1.6545454545454545
          },
          {
            "name": "Colleen",
            "popularity": 1.6453900709219857
          },
          {
            "name": "Kristine",
            "popularity": 1.5
          },
          {
            "name": "Teri",
            "popularity": 1.3880597014925373
          },
          {
            "name": "Pat",
            "popularity": 1.2592592592592593
          },
          {
            "name": "Tamara",
            "popularity": 1.2342342342342343
          },
          {
            "name": "Gayle",
            "popularity": 1.15
          },
          {
            "name": "Julie",
            "popularity": 1.1333333333333333
          },
          {
            "name": "Deanna",
            "popularity": 1.1214953271028036
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Kelly",
            "popularity": 2.236111111111111
          },
          {
            "name": "Woodrow",
            "popularity": 2.1923076923076925
          },
          {
            "name": "Rick",
            "popularity": 2.04
          },
          {
            "name": "Dave",
            "popularity": 1.9558823529411764
          },
          {
            "name": "Bob",
            "popularity": 1.9285714285714286
          },
          {
            "name": "Jim",
            "popularity": 1.8488372093023255
          },
          {
            "name": "Dan",
            "popularity": 1.7652173913043478
          },
          {
            "name": "Jason",
            "popularity": 1.6666666666666667
          },
          {
            "name": "Jeff",
            "popularity": 1.6291390728476822
          },
          {
            "name": "Mike",
            "popularity": 1.5695652173913044
          },
          {
            "name": "Brad",
            "popularity": 1.358974358974359
          },
          {
            "name": "Gordon",
            "popularity": 1.355421686746988
          },
          {
            "name": "Greg",
            "popularity": 1.3545454545454545
          },
          {
            "name": "Bill",
            "popularity": 1.2804232804232805
          },
          {
            "name": "Jon",
            "popularity": 1.2137931034482758
          }
        ]
      }
    ]
  },
  {
    "state": "WI",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Kristine",
            "popularity": 2.8295454545454546
          },
          {
            "name": "Laverne",
            "popularity": 2.4727272727272727
          },
          {
            "name": "Jodi",
            "popularity": 1.7954545454545454
          },
          {
            "name": "Marcella",
            "popularity": 1.7258064516129032
          },
          {
            "name": "Kristin",
            "popularity": 1.328358208955224
          },
          {
            "name": "Lynn",
            "popularity": 1.3274336283185841
          },
          {
            "name": "Sophie",
            "popularity": 1.278688524590164
          },
          {
            "name": "Kay",
            "popularity": 1.2314049586776858
          },
          {
            "name": "Julie",
            "popularity": 1.1573333333333333
          },
          {
            "name": "Jody",
            "popularity": 1.1343283582089552
          },
          {
            "name": "Lorraine",
            "popularity": 1.0772357723577235
          },
          {
            "name": "Violet",
            "popularity": 1.0566037735849056
          },
          {
            "name": "Jill",
            "popularity": 1.0336538461538463
          },
          {
            "name": "Arlene",
            "popularity": 1.0123456790123457
          },
          {
            "name": "Audrey",
            "popularity": 0.946236559139785
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Jerome",
            "popularity": 2.1073825503355703
          },
          {
            "name": "Lyle",
            "popularity": 2.0317460317460316
          },
          {
            "name": "Todd",
            "popularity": 1.8065693430656935
          },
          {
            "name": "Duane",
            "popularity": 1.6370967741935485
          },
          {
            "name": "Dean",
            "popularity": 1.3846153846153846
          },
          {
            "name": "Kurt",
            "popularity": 1.3837209302325582
          },
          {
            "name": "Gordon",
            "popularity": 1.216867469879518
          },
          {
            "name": "Dale",
            "popularity": 1.1525974025974026
          },
          {
            "name": "Jon",
            "popularity": 1.1310344827586207
          },
          {
            "name": "Allan",
            "popularity": 1.1294117647058823
          },
          {
            "name": "Gerald",
            "popularity": 1.089795918367347
          },
          {
            "name": "Scott",
            "popularity": 1.079696394686907
          },
          {
            "name": "Arnold",
            "popularity": 0.9196428571428571
          },
          {
            "name": "Gregg",
            "popularity": 0.8823529411764706
          },
          {
            "name": "Jeffrey",
            "popularity": 0.8070175438596491
          }
        ]
      }
    ]
  },
  {
    "state": "WV",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Patty",
            "popularity": 2.2409638554216866
          },
          {
            "name": "Opal",
            "popularity": 1.9690721649484537
          },
          {
            "name": "Dianna",
            "popularity": 1.7794117647058822
          },
          {
            "name": "Beulah",
            "popularity": 1.7790697674418605
          },
          {
            "name": "Violet",
            "popularity": 1.7735849056603774
          },
          {
            "name": "Mabel",
            "popularity": 1.6764705882352942
          },
          {
            "name": "Naomi",
            "popularity": 1.6071428571428572
          },
          {
            "name": "Nellie",
            "popularity": 1.4809160305343512
          },
          {
            "name": "Della",
            "popularity": 1.3859649122807018
          },
          {
            "name": "Tammy",
            "popularity": 1.3540489642184557
          },
          {
            "name": "Wilma",
            "popularity": 1.3448275862068966
          },
          {
            "name": "Sherri",
            "popularity": 1.1507936507936507
          },
          {
            "name": "Nina",
            "popularity": 1.1375
          },
          {
            "name": "Thelma",
            "popularity": 1.1216730038022813
          },
          {
            "name": "Maxine",
            "popularity": 1.053030303030303
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Jackie",
            "popularity": 2.606382978723404
          },
          {
            "name": "Delbert",
            "popularity": 2.2
          },
          {
            "name": "Homer",
            "popularity": 2.0428571428571427
          },
          {
            "name": "Franklin",
            "popularity": 2
          },
          {
            "name": "Woodrow",
            "popularity": 1.6538461538461537
          },
          {
            "name": "Cecil",
            "popularity": 1.6521739130434783
          },
          {
            "name": "Virgil",
            "popularity": 1.5897435897435896
          },
          {
            "name": "Willard",
            "popularity": 1.423529411764706
          },
          {
            "name": "Everett",
            "popularity": 1.2820512820512822
          },
          {
            "name": "Dana",
            "popularity": 1.2592592592592593
          },
          {
            "name": "Clyde",
            "popularity": 1.185430463576159
          },
          {
            "name": "Roger",
            "popularity": 1.1085106382978724
          },
          {
            "name": "Danny",
            "popularity": 1.0357142857142858
          },
          {
            "name": "Luther",
            "popularity": 1.0149253731343284
          },
          {
            "name": "Lewis",
            "popularity": 1.0069444444444444
          }
        ]
      }
    ]
  },
  {
    "state": "WY",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Pat",
            "popularity": 3.074074074074074
          },
          {
            "name": "Shannon",
            "popularity": 2.8941176470588235
          },
          {
            "name": "Becky",
            "popularity": 2.7981651376146788
          },
          {
            "name": "Shelley",
            "popularity": 2.550561797752809
          },
          {
            "name": "Natalie",
            "popularity": 2.4833333333333334
          },
          {
            "name": "Jody",
            "popularity": 2.417910447761194
          },
          {
            "name": "Jamie",
            "popularity": 2.3661971830985915
          },
          {
            "name": "Stacy",
            "popularity": 2.313131313131313
          },
          {
            "name": "Agnes",
            "popularity": 2.2666666666666666
          },
          {
            "name": "Shelly",
            "popularity": 2.1037735849056602
          },
          {
            "name": "Violet",
            "popularity": 2.0943396226415096
          },
          {
            "name": "Olive",
            "popularity": 2
          },
          {
            "name": "Laurie",
            "popularity": 1.9820627802690582
          },
          {
            "name": "Hazel",
            "popularity": 1.974025974025974
          },
          {
            "name": "Opal",
            "popularity": 1.9278350515463918
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Troy",
            "popularity": 5.940740740740741
          },
          {
            "name": "Jason",
            "popularity": 4.430555555555555
          },
          {
            "name": "Kelly",
            "popularity": 3.736111111111111
          },
          {
            "name": "Kim",
            "popularity": 3.5517241379310347
          },
          {
            "name": "Brad",
            "popularity": 3.08974358974359
          },
          {
            "name": "Kent",
            "popularity": 2.9571428571428573
          },
          {
            "name": "Woodrow",
            "popularity": 2.5961538461538463
          },
          {
            "name": "Brett",
            "popularity": 2.547945205479452
          },
          {
            "name": "Lance",
            "popularity": 2.5357142857142856
          },
          {
            "name": "Bob",
            "popularity": 2.2767857142857144
          },
          {
            "name": "Darin",
            "popularity": 2.0377358490566038
          },
          {
            "name": "Jim",
            "popularity": 1.9593023255813953
          },
          {
            "name": "Bill",
            "popularity": 1.693121693121693
          },
          {
            "name": "Darren",
            "popularity": 1.6701030927835052
          },
          {
            "name": "Bradley",
            "popularity": 1.6585365853658536
          }
        ]
      }
    ]
  }
]
WITH __stage0 AS (
  SELECT
    group_set,
    (floor(base.year/10))*10 as decade__0,
    base.state as state__0,
    CASE WHEN base.gender='M' THEN 'Male' ELSE 'Female' END as baby_gender__0,
    base.gender as gender__0,
    CASE WHEN group_set=0 THEN SUM(base.number) END as cohort_population__0,
    CASE WHEN group_set=1 THEN base.name END as name__1,
    CASE WHEN group_set=1 THEN SUM(base.number) END as population__1
  FROM `bigquery-public-data.usa_names.usa_1910_2013` as base
  CROSS JOIN (SELECT row_number() OVER() -1  group_set FROM UNNEST(GENERATE_ARRAY(0,1,1)))
  GROUP BY 1,2,3,4,5,7
)
, __stage1 AS (
  SELECT
    decade__0 as decade,
    state__0 as state,
    baby_gender__0 as baby_gender,
    gender__0 as gender,
    ANY_VALUE(CASE WHEN group_set=0 THEN cohort_population__0 END) as cohort_population,
    ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT(name__1 as name, population__1 as population) END IGNORE NULLS  ORDER BY  population__1 desc ) as by_name
  FROM __stage0
  GROUP BY 1,2,3,4
  ORDER BY 5 desc
)
, __stage2 AS (
  SELECT
    group_set,
    concat(by_name_0.name,'') as name__0,
    names.gender as gender__0,
    CASE WHEN group_set=0 THEN FLOOR((SUM(by_name_0.population)/CAST((
      (
        SUM(DISTINCT
          (CAST(ROUND(COALESCE(names.cohort_population,0)*(1*1.0), 9) AS NUMERIC) +
          (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001
        ))
        -
         SUM(DISTINCT (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001)
      )/(1*1.0)) as FLOAT64))*100000) END as births_per_100k__0,
    CASE WHEN group_set=1 THEN names.state END as state__1,
    CASE WHEN group_set=1 THEN FLOOR((SUM(by_name_0.population)/CAST((
      (
        SUM(DISTINCT
          (CAST(ROUND(COALESCE(names.cohort_population,0)*(1*1.0), 9) AS NUMERIC) +
          (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001
        ))
        -
         SUM(DISTINCT (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001)
      )/(1*1.0)) as FLOAT64))*100000) END as births_per_100k__1
  FROM (SELECT GENERATE_UUID() as __distinct_key, * FROM __stage1) as names
  , UNNEST(names.by_name) as by_name_0
  CROSS JOIN (SELECT row_number() OVER() -1  group_set FROM UNNEST(GENERATE_ARRAY(0,1,1)))
  WHERE names.decade<1970
  GROUP BY 1,2,3,5
)
, __stage3 AS (
  SELECT
    name__0 as name,
    gender__0 as gender,
    ANY_VALUE(CASE WHEN group_set=0 THEN births_per_100k__0 END) as births_per_100k,
    ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT(state__1 as state, births_per_100k__1 as births_per_100k) END IGNORE NULLS  ORDER BY  births_per_100k__1 desc ) as by_state
  FROM __stage2
  GROUP BY 1,2
  ORDER BY 3 desc
)
, __stage4 AS (
  SELECT
    group_set,
    by_state_0.state as state__0,
    CASE WHEN group_set IN (1,2) THEN base.gender END as gender__1,
    CASE WHEN group_set=2 THEN base.name END as name__2,
    CASE WHEN group_set=2 THEN ((by_state_0.births_per_100k-base.births_per_100k))/base.births_per_100k END as popularity__2
  FROM `__stage3` as base
  , UNNEST(base.by_state) as by_state_0
  CROSS JOIN (SELECT row_number() OVER() -1  group_set FROM UNNEST(GENERATE_ARRAY(0,2,1)))
  WHERE base.births_per_100k>50
  GROUP BY 1,2,3,4,5
)
, __stage5 AS (
  SELECT 
    CASE WHEN group_set=2 THEN 1  ELSE group_set END as group_set,
    state__0 as state__0,
    CASE WHEN group_set IN (1,2) THEN gender__1 END as gender__1,
    ARRAY_AGG(CASE WHEN group_set=2 THEN STRUCT(name__2 as name, popularity__2 as popularity) END IGNORE NULLS  ORDER BY  popularity__2 desc  LIMIT 15) as by_name__1
  FROM __stage4
  GROUP BY 1,2,3
)
SELECT
  state__0 as state,
  ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT(gender__1 as gender, by_name__1 as by_name) END IGNORE NULLS  ORDER BY  gender__1 asc ) as by_gender
FROM __stage5
GROUP BY 1
ORDER BY 1 asc